Question

Loop through SQL

  • 3 July 2020
  • 1 reply
  • 6 views
M

Dear all,

 

 

i have question about looping.

 

I have script, which is getting information from database - based on one parameter "_Powerline".

 

I'd like to loop through several values of this parameter and have many ouputs in one script. is it possible? With custom transformer? I don't have experience with this stuff.

 

Thanks in advance for help.

1 reply

ebygomm
Rank
Userlevel 1
Badge +10
Are you sure there is a need to loop? It looks to me like you send multiple triggers to the sql executor and ensure you have an attribute that you can use as a group by in subsequent transformers if necessary

Reply


Community Stats

28,664
Posts
109,338
Replies
36,533
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.