https://community.qlik.com/t5/Talend-Studio/Mapping-Issue-with-tExtractDynamicFields-Component/m-p/2496222#M141613 <P>Hi Qlik Community,</P> <P>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".</P> <P>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.</P> <P>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?</P> <P><STRONG>The job setup is described in the attached PDF.</STRONG></P> <P>Thank you for your assistance!</P> <P>Best regards, <BR />Josef</P> Thu, 05 Dec 2024 11:09:34 GMT jpronebner 2024-12-05T11:09:34Z https://community.qlik.com/t5/Talend-Studio/Mapping-Issue-with-tExtractDynamicFields-Component/m-p/2496222#M141613 <P>Hi Qlik Community,</P> <P>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".</P> <P>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.</P> <P>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?</P> <P><STRONG>The job setup is described in the attached PDF.</STRONG></P> <P>Thank you for your assistance!</P> <P>Best regards, <BR />Josef</P> Thu, 05 Dec 2024 11:09:34 GMT https://community.qlik.com/t5/Talend-Studio/Mapping-Issue-with-tExtractDynamicFields-Component/m-p/2496222#M141613 jpronebner 2024-12-05T11:09:34Z https://community.qlik.com/t5/Talend-Studio/Mapping-Issue-with-tExtractDynamicFields-Component/m-p/2542128#M149391 <P>Hello,</P><P>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.</P><P>This behavior is expected and often appears as a mapping issue when using dynamic schemas.</P><P><STRONG>Recommended approach</STRONG>:</P><P>Define one Dynamic column in the output schema of tExtractDynamicFields.</P><P>Keep any required static columns separately.</P><P>Extract or map individual dynamic values downstream using tMap, tNormalize, or custom logic.</P><P><STRONG>Note</STRONG>:<BR />Dynamic schemas are designed for flexible data structures. Explicit field extraction must be handled after the dynamic column is populated.</P><P>Thanks,</P><P>Gourav</P> Sun, 01 Feb 2026 20:37:06 GMT https://community.qlik.com/t5/Talend-Studio/Mapping-Issue-with-tExtractDynamicFields-Component/m-p/2542128#M149391 gouravdubey5 2026-02-01T20:37:06Z