- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

How to show 2 column values as column header instead of hierarchy in matrix/any other visualization?
I have one column which is in table A.
id1
QRC
SRC
MRC
I have one column which is in table B.
id2
QRF
SRF
MRF
OUTPUT:-
COLUMN HEADER:-
ID |QRC| QRF| SRC| SRF| MRC| MRF
EDIT: This is just an example, In real scenario, each column contains more than 40+ values.
I want this output scenario to happen automatically in column, not dynamically using transpose function.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

not sure if this is what you want
in PQ, appendix two tables
transpose tables
user first row as header
pls see the attachment below
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

what about merge two columns to get a new column and put that column to the matrix?
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

not sure if this is what you want
in PQ, appendix two tables
transpose tables
user first row as header
pls see the attachment below
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Yes, this is what I want, but I see you have converted it to columns using transpose and have selected each and every column to keep it in place,
But the question was an example, In future case I can have more than 40+ values in each column so instead of dynamically selecting that column, I want that it should happen automatically, all the column values should be shown as output columns without transposing it into various columns and selecting it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

what about we just appendix data and put the new column in a matrix?
pls see the attachment below
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thanks for the help,
I saw that column names are different, and I cannot change column names due to permission issues. and I edited the post accordingly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

so you want the output to change from id1 and id 2 to ID?
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Column name doesn't matter, column values matter in this situation.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

not quite understand this request. you said column names are different in the previous post. what's the problem you are facing after you used the solution i provided?
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Column names are different , so it is being generated as 2 columns as shown in screenshot below
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

what about merge two columns to get a new column and put that column to the matrix?
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Yes, It got solved thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

you are welcome
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
03-28-2024 10:50 AM | |||
07-12-2024 10:39 PM | |||
12-15-2023 12:19 PM | |||
Anonymous
| 03-08-2024 10:58 AM | ||
07-15-2024 07:05 AM |
User | Count |
---|---|
141 | |
115 | |
82 | |
63 | |
48 |