Forum Discussion
Solved
Can PowerQuery Determine How Many Concatenations are in a field?
Hey there, I have a data set where a few of the fields contain concatenated values. The values get that way because form fields will allow the user to select multiple inputs. The field is pipe delimi...
Hi gemcityzach ,
are you looking for something like this?
#"Added Conditional Column" = Table.AddColumn( #"previous step", "Concat_1_count", each Text.Length(Text.Select([Concat1], "|")) + 1, type number ), #"Added Conditional Column1" = Table.AddColumn( #"Added Conditional Column", "Concat_1_concat?", each if [Concat_1_count] > 1 then "TRUE" else "FALSE", type logical
Not sure I understand the List.Max bit. The code you provided appears to give me the count of multiple pipes in the field.