Skip to main content
Question

Losing attributes after SQLExecutor that are needed for further processing. Not sure how to get them back.


plynn
Contributor
Forum|alt.badge.img+3
  • Contributor

I am reading in a spreadsheet with 41 sheets. I get the unique values(UniqueValueLogger) and throw out the NULLs(tester). Then I hit the SQLExecutor that runs for each of the unique values. Next is the NoFeatureTester. If a work order exists, it drops to the OpenWorkorders transformer which writes the information to a file. If there are no open work orders, I need those unique values to be sent to the next SQLExecutor for further processing. How can I get those unique values back out to send to the 2nd SQLExecutor transformer?

2 replies

debbiatsafe
Safer
Forum|alt.badge.img+20
  • Safer
  • October 21, 2021

Hi @plynn​ 

In the SQLExecutor, there is a parameter called Combine Attributes. If you want the attributes from the UniqueValueLogger, change this parameter value to Keep Initiator Attribute if Conflict for both SQLExecutor transformers.


f.kemminje
Contributor
Forum|alt.badge.img+11
  • Contributor
  • October 22, 2021

tosafeq1


Reply


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