Rename Fields Using FieldMap - Partial Load

aadil_madarveet — Thu, 01 Dec 2022 13:04:36 GMT

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

Re: Rename Fields Using FieldMap - Partial Load

rachel_delany — Mon, 12 Dec 2022 01:55:42 GMT

Have you put REPLACE in front of your mapping load?

topic Rename Fields Using FieldMap - Partial Load in App Development

Rename Fields Using FieldMap - Partial Load

Re: Rename Fields Using FieldMap - Partial Load