Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

New rows from columns

Hi folks, I'm trying to create new rows from columns. Eg.: From this:   To this: Any help?
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    Please try:

    New Table = 
var _t1=SELECTCOLUMNS('Table',"Name",[Column1],"Start",[Column2],"End",[Column3])
var _t2=SELECTCOLUMNS('Table',"Name",[Column1],"Start",[Column4],"End",[Column5])
return FILTER( DISTINCT( UNION(_t1,_t2)) ,[Start]<>BLANK() && [End]<>BLANK())

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

Please try:

New Table = 
var _t1=SELECTCOLUMNS('Table',"Name",[Column1],"Start",[Column2],"End",[Column3])
var _t2=SELECTCOLUMNS('Table',"Name",[Column1],"Start",[Column4],"End",[Column5])
return FILTER( DISTINCT( UNION(_t1,_t2)) ,[Start]<>BLANK() && [End]<>BLANK())

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.