Forum Discussion
How to get data cleaned up
I have a table with multiple columns How can I only get customer name when some line items have partner info followed by : If I extract before: it also removes the customer name with no : ...
In such case, I would add a colon to those values which don't have it at approriate place and then apply the transformation
Sorry this gives the opposite to what I required
I need the text after the delimiter and not to delete the customers without a delimiter
If you expand the advanced options and set the scan as from the end of the input, it should work the way to want. I verified this with a sample data
Before-
After-