How to create dynamically columns side by side by particular IDs

[ravi061]

Hi,

I got urgent requirement to add "difference" columns dynamically for every IDs Columns, shown as below table, Calculation for the "Difference" column is  [ (P+N)-K ]

Below case is for few ID columns, but i have nearly 600 ID columns.

Attached Difference Calculation column is calculated by (P+N)-K for all IDs, How can we achieve this requirement, for some IDs K or P or N columns will be not available.

Thanks in advance for your help...

[caltang]

I'm sorry but I don't think I quite understand your query. Are you trying to get the difference between Ks, Ps, and Ns?

Perhaps you can attach a sample dataset and some expected outputs to better guide us to guide you?

[ravi061]

Sorry for that @caltang, I mean for every similar ID strings need to create a calculation column(Difference) as shown on the attached screenshot.

Example: For 52515, there are three columns,

                      52515-K

                      52515-P

                      52515-N

Need to create formula column dynamically(Difference), Formula here is  (52515-P+52515-N)-52515-K,

For some ID String columns, there will be no Ps or Ns or Ks, then we need to keep it as zero for those columns in the formula or calculation columns...

[caltang · Accepted solution]

Hi @ravi061 

Is this what you are looking for?

You will still need to sort at the end using Select Tool to get what you want. But I hope this gives you some ideas.