Updating multiple column value of single row for respective records

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

Transformation

Preparation

Text Mining

Accepted answers

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

All comments

@ajanayak One way of doing this

Transpose_013023.yxmd

Please make use of the Transpose tool.

It will help...

Many thanks

Shanker V

One way of doing this!!!!

Many thanks

Shanker V

Step 1; Input

Step 2:

Step 3:

Many thanks

Shanker V

Step 4: Cross tab tool

Step 5: Helps to rename the column name correctly.

Hope this helps!!!

Many thanks

Shanker V

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

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15878

MarqueeCrew 13708

apathetichell 13703