How to input the entire query from file to tDBInput

[Anonymous]

Hi,

Can we dynamically input query to tDBInput.

I mean to say, I will store list of queries in a file having same output schema.

tFileInputExcel--->row1(main)--->tFlowTolerate--->iterate-->tDBInput

So, query part of tDBInput has  to take query from the iteration.

I tried putting " '" + globalMap.get("row1.SqlQuery") + "' "

Am I going wrong, anyway I got error doing this way.

Can I have some alternate solution?

Thanks in advance,

Meghana.

[Anonymous]

It is not working. 

Can u please try this.

Thanks.

[Anonymous · Accepted solution]

Issue solved.

The solution is 

(String)globalMap.get("row2.SqlQuery")

without double quotes.

Thanks,

Meghana.