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
Solved! Go to Solution.
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
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 : )
Thank you @AngelosPachis!
Thank you @atcodedog05
Happy to help : ) @wcamarg3
Cheers and have a nice day!