Forum Discussion

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

newpi 
You have blank values. Please use https://www.dropbox.com/t/47luIKUpiLZmAFIO

Values Correct Order = 
VAR String = Data[Values]
VAR ConvertPath = SUBSTITUTE ( String, ",", "|" )
VAR Length = COALESCE ( PATHLENGTH ( ConvertPath ), 1 )
VAR T1 = GENERATESERIES ( 1, Length, 1 )
VAR T2 = ADDCOLUMNS ( T1, "@Items", PATHITEM ( ConvertPath, [Value] ) )
RETURN
    CONCATENATEX ( T2, [@Items], ",", [@Items], ASC )

 

newpi's avatar
newpi
Icon for Helper V rankHelper V
4 years ago

Thanks tamerj1 but now getting a new error.
Cannot convert value 'Remote Work' of type Text to type Integer.
"Remote Work" is one of the values (ab c)

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Good morning newpi 
    I have tried all types of texts I could think of but failed to simulate the error you receive. Please share some sample data including the line that generates the error so I can simulate it and fix it. Thank you.