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.
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