Updating multiple column value of single row for respective records

[ajanayak]

Hello Team,

Please help me to use the Multi field formula wherein I have a requirement when I need to update more than twenty column for respective items, I can do that by using Formula tool but I think that is not the optimized way to do it, Please help me to resolve the issue by using Multi Field formula,

NOTE --> I have attached my input and output file expected. Thanks in advance.

Thanks

AJAY

[binuacs]

@ajanayak One way of doing this

[ShankerV]

hi @ajanayak 

Please make use of the Transpose tool.

It will help...

Many thanks

Shanker V

[ShankerV]

Hi @ajanayak 

One way of doing this!!!!

Many thanks

Shanker V

[ShankerV]

Hi @ajanayak 

Step 1; Input

Step 2:

Step 3:

Many thanks

Shanker V

[ShankerV]

Hi @ajanayak 

Step 4: Cross tab tool

Step 5: Helps to rename the column name correctly.

Hope this helps!!!

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @ajanayak 

Additional 3 steps added to make sure the output is in order.

Step : Record ID

Step:

Step: Select

Hope it helps!!!

Many thanks

Shanker V