Forum Discussion
Solved
CUT OF STRING AT END
Hey guys Today I struggled upon an issue i can't seem to resolve on my own. The data I receive consists of a string value which on its own consists of 3 values split by a comma, e.g. ABCD, EFGH, ...
First, split the rows by a delimiter.
This will give you 3 columns (or more depending on your strings). Just remove the 3rd column
If you're wanting to create rows from these values.... Select both rows and Transform > Unpivot Columns
First, split the rows by a delimiter.
This will give you 3 columns (or more depending on your strings). Just remove the 3rd column
If you're wanting to create rows from these values.... Select both rows and Transform > Unpivot Columns