Skip to main content
Question

Loop through SQL

  • July 3, 2020
  • 1 reply
  • 43 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
Influencer
Forum|alt.badge.img+38
  • ebygommInfluencer
  • Influencer
  • July 3, 2020
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


Helpful Members This Week

Community Stats

31,341
Posts
118,853
Replies
38,930
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.