I have data like
a b c
1 0 0 0
2 0 0 0
3 1 1 1
I want new columns added for every column
a ref-a b ref-b c ref-c
1 0 null 0 null 0 null
2 0 null 0 null 0 null
3 1 null 1 null 1 null
I tried multi field and the fields were created but they were created all at the end of all columns. I want new columns simultaneously and do not want to reorder since in actual I would be dealing with over 500 columns.
Thanks:)
Hi @rajatjain1
Here is a workflow for the task.
Output: dynamically creates column ref after a column
Workflow:
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
@rajatjain1 could you use the Multi-Field Formula tool to create a new field for each column with "a_ as a Suffix"?
Once you have all the columns created, you can use a Select Tool to go to Options> Sort > Sort on Field Name> Ascending.
HI @rajatjain1 , give this a try but remember that the matrix should be n*n like in your example you took 3*3 matrix. It is dynamic workflow.
Matrix you provided
My Tested matrix.
If this is what you are looking for kindly mark this post as solution.
Thanks.