Forum Discussion
Create a table with unique list
Hi Forum, I have this table Mat Desc Material Number SubMat1 SubMat2 SubMat3 SubMat4 SubMat5 xxx 103842 39006582 100362311 43805638 43090505 null xxx 103842 39006582 4375...
You should unpivot your data to make this easier. In the query editor, select the first two columns, right click on them, and choose unpivot other columns. Once you load that table, you can use a measure with CONCATENATEX() to combine the values for each material in a table visual.
Pat
You should unpivot your data to make this easier. In the query editor, select the first two columns, right click on them, and choose unpivot other columns. Once you load that table, you can use a measure with CONCATENATEX() to combine the values for each material in a table visual.
Pat
Thanks Pat ! I am nearly there.
The table I see now is
Mat Desc Mat Number Attribute Value xxx 123 Sub Name yyyyy xxx 123 Sub Number 3456 xxx 123 Sub Type Type 1 How do it convert this to.
Mat Desc Mat Number Sub Name Sub Number Sub Type TIA.