https://community.qlik.com/t5/Talend-Studio/Using-context-variables-in-tFileInputJson-Mapping/m-p/2325939#M95479 <P>Hello people! Please, help me.</P><P></P><P></P><P>I have two identical jobs which use the tFileInputJson component. One job uses strings in the Json query (Mapping section). Like "[0]", "[1]", etc.</P><P></P><P></P><P>The other job uses context variables that I load from an Excel file. So the mapping looks like context.n_order_id, context.n_order_nbr, etc.</P><P></P><P></P><P>This is the only distinction between the two jobs.</P><P></P><P></P><P>Now, when I run the first one (with constant strings as Json query in the Mapping section), I get the JSON file parsed correctly and exported to a csv file. When I run the second job, I get a file full of empty records.</P><P></P><P></P><P>So, what I am doing wrong?</P><P></P><P></P><P>Thanks in advance!</P> Sat, 16 Nov 2024 00:37:07 GMT Konstantin_Lisyanskiy 2024-11-16T00:37:07Z https://community.qlik.com/t5/Talend-Studio/Using-context-variables-in-tFileInputJson-Mapping/m-p/2325939#M95479 <P>Hello people! Please, help me.</P><P></P><P></P><P>I have two identical jobs which use the tFileInputJson component. One job uses strings in the Json query (Mapping section). Like "[0]", "[1]", etc.</P><P></P><P></P><P>The other job uses context variables that I load from an Excel file. So the mapping looks like context.n_order_id, context.n_order_nbr, etc.</P><P></P><P></P><P>This is the only distinction between the two jobs.</P><P></P><P></P><P>Now, when I run the first one (with constant strings as Json query in the Mapping section), I get the JSON file parsed correctly and exported to a csv file. When I run the second job, I get a file full of empty records.</P><P></P><P></P><P>So, what I am doing wrong?</P><P></P><P></P><P>Thanks in advance!</P> Sat, 16 Nov 2024 00:37:07 GMT https://community.qlik.com/t5/Talend-Studio/Using-context-variables-in-tFileInputJson-Mapping/m-p/2325939#M95479 Konstantin_Lisyanskiy 2024-11-16T00:37:07Z https://community.qlik.com/t5/Talend-Studio/Using-context-variables-in-tFileInputJson-Mapping/m-p/2325940#M95480 <P>check if your context variables get values from the excel file</P> Thu, 18 Feb 2021 11:17:00 GMT https://community.qlik.com/t5/Talend-Studio/Using-context-variables-in-tFileInputJson-Mapping/m-p/2325940#M95480 houssem_B 2021-02-18T11:17:00Z https://community.qlik.com/t5/Talend-Studio/Using-context-variables-in-tFileInputJson-Mapping/m-p/2325941#M95481 <P>Well, they do. I used TLogView to check.</P> Fri, 19 Feb 2021 23:11:45 GMT https://community.qlik.com/t5/Talend-Studio/Using-context-variables-in-tFileInputJson-Mapping/m-p/2325941#M95481 Konstantin_Lisyanskiy 2021-02-19T23:11:45Z