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?
Question
Losing attributes after SQLExecutor that are needed for further processing. Not sure how to get them back.
+21- Safer
- 648 replies
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.
