Save FilePath (or query) while using Dynamic Input tool to retrieve from DW

[migle-maciuleviciute]

Dear all, 

I have been using the Dynamic Input tool to change a specific string in my query (Invoice ID). Everything works fine, except I cannot distinguish which data is taken from which query as the file path cannot be added. However, while running, I can see in the Results workflow how many data lines were retrieved from each query.

My question is whether or not there is a possibility to add a separate column of the query that was used in the Dynamic Input tool? 

Thanks! 

[RolandSchubert · Accepted solution]

Hi @migle-maciuleviciute ,

you can easily add a field containing the "variable" part of your query as an identifier.

In my sample,  I connect to a SQL database (Microsoft sample db) and select CustomerID. In the Dynamic Input tool, I use this field to modify my SQL to restrict to a specific CustomerID for each query. In addition, I use "Pass a Field to the Output" to add the specific replacement leading to the result to the dataset.

What do you think?

Best,

Roland 

[migle-maciuleviciute]

Thank you so much! It helped :)