Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
jpronebner
Contributor II
Contributor II

Mapping Issue with tExtractDynamicFields Component

Hi Qlik Community,

I am currently working on a test job to illustrate a problem I am facing. I have an Excel file with four columns, one of which is named "Straße/Hausnr". Using the tExtractDynamicFields component, I aim to map the columns from the dynamic schema of the Excel component to a target column named "Strasse_Hausnr".

However, in the output of tLogRow_1, the value for "Straße/Hausnr" is always null. The mapping of the columns is supposed to occur based on the matching of the Excel column names with the column names configured in the schema. Unfortunately, I am unable to get the value to map correctly.

I understand that I could change the column name in the Excel file, but the data is provided to me in this format. How can I resolve this issue so that the Excel column "Straße/Hausnr" maps correctly to "Strasse_Hausnr"? Is there a naming convention on how the columns of the source are allowed to be named?

The job setup is described in the attached PDF.

Thank you for your assistance!

Best regards,
Josef

Labels (1)
  • v8.x

0 Replies