Forum Discussion
Helper VHow 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.
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
what about merge two columns to get a new column and put that column to the matrix?
11 Replies
ryan_mayuSuper User
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
Jessica_17Yes, 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.- ryan_mayu
what about we just appendix data and put the new column in a matrix?
pls see the attachment below