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.