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?