LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: a7n

Hi All

I want to split the output based on the column values.

I know that i can do a histogram on Name & use a filter node and use the output function 4 times and create 4 outputs. But this is a very manual process and takes lot of time.

I would like to automate this by just using 1 or a combination of nodes where i give the node/s the col name and it automatically creates number of output bases on the column values

ie for the below data
ID,Name
1,aa
2,bb
3,ss
4,ss
5,ss
6,cc
7,cc
8,aa

Attached screenshot...of what i am currently doing
Capture.JPG

Hope it made sense.
LAE 4.5

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: gmullin

You can't dynamically create the number of output pins on a node. You can leave the output pins there and have 0 records output to them. I was thinking you could use a Do While node to circle through your data until you're done but that node won't be available to you in v4.5.

Are you on a server? You could possibly do one part of your graph as BRX and use Name as a run parameter and feed that into your Execute BRX node that would do whatever you need to for each value of Name, whether it be once or 4 times.