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
In such case, I would add a colon to those values which don't have it at approriate place and then apply the transformation
Was my mistake
Thank you, for sticking with me 🙂