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?
Page 1 / 1
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.
