LAE

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

Originally posted by: Iain Sanders

Hi guys,

Please advise what library node and BRAINScript I can use to prepare a list of different field values of a particular field, to split the original table containing that field into multiple outputs by field value.

e.g. original (input) table is:

NetworkID Tariff GXP Code
33 HH2 RT03101
33 HG2 RT03102
35 GF1 RT03102
36 GF2 RT03104
36 FD0 RT03101
37 FF0 RT03104
38 FF0 RT03103
38 FF1 RT03103
39 FF2 RT03101

I want a separate table for:

NetworkID = 33, 35, 36, 37, 38, 39.

All the best,

Iain

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

Originally posted by: ltolleson

Iain,

Can you please explain what you mean by "split the original table containing that field into multiple outputs by field value".

Does this mean you want to output multiple rows, or to have multiple outputs for node?

Are you trying to rotate the data such that Network ID would be the first value in a field called NAME and the id's would be a comma separated list of values in a field called VALUE.

Example

NAME VALUE
NetworkID 33, 35, 36, 37, 38, 39

With a little more detail and definition we can definitely help you with the code.

Thanks,

Larry

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

Originally posted by: Iain Sanders

Hi Larry,

Thank you for helping. I've resolved the issue now.

I wanted to have multiple outputs for a filter node based on different values for a data field in the input.

This is now understood.

Thanks.

Iain