How to create multiple columns based on some conditions

Hi all,

I hope anyone can help me.

I have a table which has the "Line", the "Operation" and the "Serial Number".

Line	Operation	Serial Number
A_ONE	10	123782
A_ONE	20	123783
B_ONE	20	123784
B_TWO	30	123785
C_ONE	40	123786

And I would like to create another columns segregated by the "Line" and "Operation" name containing the respective Serial Numbers inside these columns.

To better understanding follow below the desired output:

A_ONE OP10	A_ONE OP20	B_ONE OP20	B_TWO OP30	C_ONE OP40
123782	123783	123784	123785	123786

Thanks,

Wil

Workflow

Developer

Developer Tools

Accepted answers

AngelosPachis

Hi @wcamarg3 ,

You can use a formula tool to form the column headers and then cross tab your table to get the desired output

Hope that helps,

Angelos

example.yxmd

atcodedog05

Hi @wcamarg3

Here is how you can do it.

Workflow:

1. Using formula tool to create new column name.

2. Using formula tool to convert serial number int datatype to string.

3. Using crosstab tool to convert to table.

4. Using dynamic rename to fix the names.

Hope this helps : )

rotate.yxmd

All comments

AngelosPachis

Hi @wcamarg3 ,

You can use a formula tool to form the column headers and then cross tab your table to get the desired output

Hope that helps,

Angelos

example.yxmd

atcodedog05

Hi @wcamarg3

Here is how you can do it.

Workflow:

1. Using formula tool to create new column name.

2. Using formula tool to convert serial number int datatype to string.

3. Using crosstab tool to convert to table.

4. Using dynamic rename to fix the names.

Hope this helps : )

rotate.yxmd

wcamarg3

Thank you @AngelosPachis!

wcamarg3

Thank you @atcodedog05

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703