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?
tExtractDynamicFields works by resolving dynamic fields at runtime and placing them into a single Dynamic column. It does not automatically expand dynamic attributes into individual schema columns.
This behavior is expected and often appears as a mapping issue when using dynamic schemas.
Recommended approach:
Define one Dynamic column in the output schema of tExtractDynamicFields.
Keep any required static columns separately.
Extract or map individual dynamic values downstream using tMap, tNormalize, or custom logic.
Note: Dynamic schemas are designed for flexible data structures. Explicit field extraction must be handled after the dynamic column is populated.
