Data360 Analyze

Hello, 

I am reading an Excel file and sending each worksheet tab to its own Excel node output pin.  There are 5 Excel worksheets so now there are 5 output pins.  That works just fine.

Each worksheet has a different structure.  However there is one column they all have in common and I'd like to apply a condition to that column.  I'd like all 5 Excel output pins to pass into the same Transform Node.  The Transform Node has only 1 input pin and will only accept one input.  I'm not able to add new input pins to the Transform Node.  I thought this would be as easy to do as creating the new output pins.  

Is there a way to accomplish this?  I don't want to have 5 transform nodes all doing the same thing if possible.  I'd rather have 1 transform node and pass all inputs through it.  

Thanks,

Rob

Do you want to work ONLY with that column, or do you want to keep the other columns also?

If you wanted to work with only that one column, then you can input all 5 sources into a CAT node, and select "Intersection" for the concatenation type.   The CAT node in that case would output only the common columns.

Another (less appealing) choice is to use the "Union" concatenation option.. this would create a lot of empty cells, but the columns from each row would be intact.

Otherwise, your only choice is to go with 5 of the Transform nodes.

Thanks for laying out the options, Stony.  That makes sense.