LAE

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

Originally posted by: dhrobertson

Hi,

would anyone know of a way to split out a dataset based upon a column in the data?

in this example a have a few codes. I would like to split them out to distinct outputs if possible... I'm thinking along the line of a while statement and do output, with the while based upon while the code is the same output to pin 1 somehow, when it changes, output to pin 2, when it changes output to pin 3 etc. etc.....
I cant really think that this is possible as the script cant dynamically create outputs but if anyone has any kind of suggestions about what I could possible do, that would be a great help...
thanks Doug


code:string
10778619
10748528
10332774
10332774
10749268
10742513
10742513
10755620
10626099
10220345

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

Originally posted by: stonysmith

How many unique codes do you have to deal with? How many total records are there to process?
There are a couple of possiblities.

The other question is how do you want to deal with the codes after that.
If each code needs its own set of filters/business rules, it will get complicated <grin>

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

Originally posted by: dhrobertson

Originally posted by: stonysmith
					

How many unique codes do you have to deal with?  How many total records are there to process?

There are a couple of possiblities.


The other question is how do you want to deal with the codes after that.

If each code needs its own set of filters/business rules, it will get complicated <grin>
			

In this specific case there are 20 unique codes, however that may change over time. the dataset has roughly 800 rows of data. there is no special processing required of the data after that, it is really just a case of splitting out the rows based on the codes so that each set of data can be written to an independent output.

I personally cant think of a way to split it out physically....

If you have any thoughts of a roundabout method to achieving this result, that would be great!

thanks for the help

doug

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

Originally posted by: martinh1976

Hi Doug - I know this is an old topic but did you get it resolved in the end. I have exactly the same issue. Although I can get around it by explicitly stating the values to output each PIN sometimes i just dont know what they will be!

Thanks

Martin

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

Originally posted by: gmullin

Would the Do While node be useful to you? An example is attached here.

do_while_example.brg

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

Originally posted by: mmarinelli

I think that the request revolves around dynamic creation of output pins based upon the number of discrete values within a column of data. This is not (currently) supported by the software, as the number of pins needs to be set at design time.

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

Originally posted by: online

I personally cant think of a way to split it out physically too.