Create Columns next to original columns

[rajatjain1]

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:)

[atcodedog05]

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 😀👍

[porter_samu]

@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. 

[grazitti_sapna]

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.