Hello people! Please, help me.
I have two identical jobs which use the tFileInputJson component. One job uses strings in the Json query (Mapping section). Like "[0]", "[1]", etc.
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.
This is the only distinction between the two jobs.
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.
So, what I am doing wrong?
Thanks in advance!
