Manipulatinig Data Item

[polinenileela_b]

Hi, I am doing a process which takes all the queries from the excel sheet and put in to a collection and loop them to run .. before running the query I have to manipulate the query by adding the from date and to date and run .. Actually I have added the Collection result to a data item , so every time it runs it will store the next query but.. I want to manipulate that query.. Can any one of u suggest the way to do .. most help full.. ' Thanks

[ShreyansNahar1]

Hi Leela, Once stored in a data item, you can directly use the calculation stage to manipulate the query. Or you can directly manipulate the query in the collection itself. If you want to add the From/to date in the query at a specific location, try using the InStr function which will give you the location of the text after which you want to replace. You an also use the Replace function for direct replacements.

[polinenileela_b]

Thank you Shreyan, used replace method.. thanks for the help 🙂