Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
aadil_madarveet
Partner - Creator II
Partner - Creator II

Rename Fields Using FieldMap - Partial Load

Hi All,

I have a requirement to update one table with a partial load concept of Qlik Sense. The partial load should just drop the table and recreate it from the DB. so using a simple REPLACE LOAD statement for the load. But after the table is loaded into the table, I have to dynamically identify the field names from one of the fields in the loaded table and assign the field names. I am able to achieve this using the mapping table-based renaming of fields.

The problem is that during PARTIAL LOAD the statement "RENAME FIELDS USING FIELDMAP" is not getting executed and hence the table is loaded, but the fields are not renamed.

Any suggestion on how to handle the renaming of fields using field map in a partial load.

Using QlikSense Feb 2022 P8

Thanks,

Aadil

Labels (3)
1 Reply
rachel_delany
Creator II
Creator II

Have you put REPLACE in front of your mapping load?