Hi Guys,
I have a input with 100 column named as say for example AAAAA,BBBBB,CCCCC,DDDDD. And the contents in every column is "X". Now what my requirement is I want to copy the column title like "AAAAA" to its column value "X". I know it can be done with simple formula using formula tool. But my concern is since I have around 150 rows for which the same thing is done, is there any simple way to do this so.
Please help me on this guys
Résolu ! Accéder à la solution.
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
@Gsiva3
I hope this is what you need.
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.
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.
Hi @Gsiva3
This is my solution for you.
I add count logic for that workflow.
1. Count by Summarize tool
2. Join with Record ID
Thank you so much @AkimasaKajitani
Is absolutely working fine.
I have one final 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
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