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
You can try below steps:
1. I have created a sample data with one row
2. Right click on header. Go to split column and choose 'by delimiter'
3. Fill the pop up window like below and click on okay
4. your data is now split
Sorry this is what I have been doing but it removes the original customer without a delimiter see attachment
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 🙂