Forum Discussion
Listing Values, Columns Axis
Columns don't have values. They have row numbers (or indexes) which then point to cells that have values.
To swap columns and rows you can use Pivot/unpivot transforms.
You would need to run a custom function that identifies the names of the columns containing cellse with the value "green".
Then you would do a SelectColumns against that list
Then you would do the pivoting thing to swap rows and columns.
Now the question is - how many rows does your table have? This might be fine for 20 rows, but will certainly not work for millions of rows.
Thanks for the reply. I have a few hundred columns and only a few hundred rows. I have no clue, yet, on how to do what you mentioned although it moves the ball forward and I will research it. Thanks!
For your proposed solution, do you have any direction to perform/create the function?
provide some sample data and the expected result
Hi, here's the same information. For my real data, I have hundreds title, description and "status" columns.
Audit_ID Audit_Date Company_ID ABC123_Title ABC123_Description ABC123_Status XYZ123_Title XYZ123_Description XYZ123_Status 1 1/1/20
1 ABC123_Title #1 ABC123_Description #1 Implemented XYZ123_Title #1 XYZ123_Description #1 Not Implemented 2 2/1/20 2 ABC123_Title #2 ABC123_Description #2 Implemented XYZ123_Title #2 XYZ123_Description #2 Not Implemented 3 3/1/20 3 ABC123_Title #3 ABC123_Description #3 Implemented XYZ123_Title #3 XYZ123_Description #3 Not Implemented 4 4/1/20 4 ABC123_Title #4 ABC123_Description #4 Implemented XYZ123_Title #4 XYZ123_Description #4 Not Implemented 5 5/1/20 5 ABC123_Title #5 ABC123_Description #5 Implemented XYZ123_Title #5 XYZ123_Description #5 Not Implemented Ideally I would like to have a report showing the following:
Company 1
Date Performed (1/1/20)
Implemented ABC123_Title Not Implemented XYZ123_Title
