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.