2084711 - Error - File empty or format invalid When Uploading Lookup Table - Compensation

SAP Knowledge Base Article - Public

2084711 - Error - File empty or format invalid When Uploading Lookup Table - Compensation

Symptom

  • You have created a Lookup table only by giving name and description and you receive the error File empty or format invalid
  • File empty or format invalid

Environment

  • Compensation

Cause

  • You have created a Lookup table only by giving name and description

      1.png

  • Once created Number of Input and Number of Output will be 1 by default.

       2.png

  • Now, if you are uploading .csv file with more than two columns for e.g. three columns

      3.png

  • You will receive the error “File empty or format invalid

      4.png

  • You will receive the same error message, if you are trying to edit existing Lookup table by importing a new file with different number of columns compared to one already imported.

 

 

Resolution

  • Always give the Number of Inputs (Keys) and Number of Outputs (Values) while creating a lookup table. Please make sure that (Number of Inputs + Number of Outputs) =No of columns in your csv file.
  • Example: You have total three columns (MV_Title,GRADE and Value) in your csv file and based on MV_Title and Grade the Value will be displayed on the form. Here you have two Keys i.e. MV_Title, GRADE and one Value i.e. Value (based on the keys value will be displayed on form).So you can create a look up table with Number of Input=2 and Number of Output=1

 

  • Note: You can upload maximum five input fields and five output fields in a Lookup table.

Keywords

KBA , sf compensation manage data , LOD-SF-CMP , Compensation Management , How To

Product

SAP SuccessFactors HCM Core all versions