Forum Discussion

space83's avatar
space83
Icon for Helper IV rankHelper IV
4 years ago

make 6 row become 1 row

Hi all,   This 2 table below actually come from same table in model. How can I show the 2nd table (workorder) in table 1 as new column in 1 row and separate by comma?   as example it will be som...
Need Help
Show and Tell
Tips and Tricks
space83's avatar
space83
Icon for Helper IV rankHelper IV
4 years ago

hi JYA ,

 

Seems it still not produce an expected result.

actually my table is single table only.

JYA's avatar
JYA
Frequent Visitor
4 years ago

Ok, 

I have created the table with only Article nr. and Workorder :

Planner Combine = DATATABLE("Article nr.",STRING,"Workorder",STRING,{{"MY10290.1","2021025087"},{"MY10290.1","2021025098"},{"MY10290.1","2021025468"},{"MY10290.1","2021025246"},{"MY10290.1","2021025304"},{"MY10290.1","2021025706"},{"MY10950.1","202102000"},{"MY10950.1","2021025001"},{"MY10950.1","2021025002"}})
 
and using 
Workorder list =
CONCATENATEX('Planner Combine','Planner Combine'[Workorder],", ")
 
Create table like this 

Count of Workorder is distinctcount

I get this :