Need to change column values as title of the respective column

Dynamic Processing

Accepted answers

This is my solution for you.

1. Add the Record ID to keep the Record Position

2. Transpose

3. Copy the Field Name to Value by Formula tool

IF IsNull([Value]) THEN Null() ELSE [Name] ENDIF

At this time, if the field size of the Value is shorter than the name of the field, it will not be copied properly, so you may need to change the field length by using Select tool.

4. Cross Tab

CopyColumnNametoValue_AK.yxmd

Qiu

@Gsiva3
I hope this is what you need.

1228-Gsiva3.yxzp

This is my solution for you.

I add count logic for that workflow.

1. Count by Summarize tool

2. Join with Record ID

CopyColumnNametoValue_AK2.yxmd

This is my solution for you. It is a little complex workflow.

CopyColumnNametoValue_AK3.yxmd

Qiu

@Gsiva3
I guess I am a bit late for the party, but this is my solution for you.

And hope can finally get your accept mark for my solution.

1228-Gsiva3-r1.yxzp

All comments

Hi @Gsiva3

This is my solution for you.

1. Add the Record ID to keep the Record Position

2. Transpose

3. Copy the Field Name to Value by Formula tool

IF IsNull([Value]) THEN Null() ELSE [Name] ENDIF

At this time, if the field size of the Value is shorter than the name of the field, it will not be copied properly, so you may need to change the field length by using Select tool.

4. Cross Tab

CopyColumnNametoValue_AK.yxmd

Qiu

@Gsiva3
I hope this is what you need.

1228-Gsiva3.yxzp

Gsiva3

S got it. Thanks @AkimasaKajitani

But my another concern is after doing this, I want to add entries in all those column in a column named count. I have attached sample input & output here.

Please help me with this.

Gsiva3

S got it. Thanks @Qiu

But my another concern is after doing this, I want to add entries in all those column in a column named count. I have attached sample input & output here.

Please help me with this.

This is my solution for you.

I add count logic for that workflow.

1. Count by Summarize tool

2. Join with Record ID

CopyColumnNametoValue_AK2.yxmd

grazitti_sapna

Hi @Gsiva3,

Here is my take on your problem.

I hope it helps.

Changing Column Values.yxmd

Gsiva3

Thank you so much @grazitti_sapna

I have already got it.

I have one more request. I have a rows named 12,13,14 & MKT, in which MKT is alone empty.

Now what I want is IF Value in Count column is 4, I want to create 4 empty rows and copy the values of 12,13,14 to those four empty rows, but for the market row alone, since count is 4 in that row " values in that cells are AAAAA,BBBBB,CCCCC,DDDDD" I want these contents to be copied to the market column. My output should be like "IF value count column is 4, then I need 4 rows along the values for 4 rows in column 12,13,14 whereas for MKT column alone, in the generated 4 rows, I want AAAAA in one row, BBBB in one row, CCCCC in one row, DDDDD in one row.

Please help me with this if it is possible.

Attached sample input & output