Create Columns next to original columns

Question

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

grazitti_sapna · Answer

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.

porter_samu · Answer

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

atcodedog05 · Answer

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

ref.yxmd