Forum Discussion
Betty888
Helper II
Helper IIHow to create a new column with a different concatenation
Dear all, I'm not sure what I will descrive will be easy to understand, not even whether it is possible or not, but I'll try .... I have a table with 3 columns where information were concatenate...
Hello Betty888,
Can you please try this:
Col4 = VAR Products = SUBSTITUTE([col1], ";", "|") VAR Doses = SUBSTITUTE([col2], ";", "|") VAR Labels = SUBSTITUTE([col3], ";", "|") VAR ProductList = GENERATE(SPLIT(Products, "|"), SPLIT(Doses, "|"), SPLIT(Labels, "|")) RETURN CONCATENATEX(ProductList, [Column1] & " " & [Column2] & " " & [Column3], CHAR(10))
Sahir_Maharaj
Super User
Super UserHello Betty888,
Can you please try this:
Col4 =
VAR Products = SUBSTITUTE([col1], ";", "|")
VAR Doses = SUBSTITUTE([col2], ";", "|")
VAR Labels = SUBSTITUTE([col3], ";", "|")
VAR ProductList = GENERATE(SPLIT(Products, "|"), SPLIT(Doses, "|"), SPLIT(Labels, "|"))
RETURN
CONCATENATEX(ProductList, [Column1] & " " & [Column2] & " " & [Column3], CHAR(10))
Betty888Helper II
Helper IIWorks perfectly for me , many many thanks 🙏🙏🙏