Forum Discussion
Solved
Concatenate a list in a custom column
Hi, Wondering if you can help. It sounds easy but i am having trouble doing it. So i have a table with once column as below Value list a b c I need to create a new column in the...
NewStep=Table.AddColumn(PreviousStepName,"Custom",each "["&Text.Combine(PreviousStepName[sup],",")&"]")
Vijay_A_Verma
Most Valuable Professional
Most Valuable ProfessionalUse following
=Text.Combine([Data],",")
Where Data is the name of the column which holds the list
Hi Vijay,
Thanks for your promp response.
Unfortunately i am getting an error using your formula. I have 63 items ( this can increase in the future) and i need to combine all these values starting with a square bracket followed by each item followed by a comma and a closing square bracket at the end. i.e. [a,b,c,d,e,f]
Am i getting a error due to the lenght of the string perhaps?
- Vijay_A_Verma
Can you please post the screenshot of your error?
- wdx223_Daniel
Community Champion
NewStep=Table.AddColumn(PreviousStepName,"Custom",each "["&Text.Combine(PreviousStepName[sup],",")&"]")