Hi everyone,
I want to split multiple columns value. one evseId have one chargingNetwork and Country but powerType, Price and PriceType Could be one or two. In some columns more then 2 evseId. each evseId have at least one chargingNetwork and Country but powerType, Price and PriceType Could be one or two.
Below I attached sample data file.
@binuacs Yes I tried but I just split one column at once if I repeat for chargingNetwork It duplicate evseId and same if I apply text-to-columns tool again for powerType so then it again duplicate evseId and also chargingNetwork. at the end one evseId repeated multiple time which is not right.
As you can see in the screenshot. evseId (24487-1) just have one id, chargingNetwork and country but PowerType, Price and PriceType were two but when I split for each one just (24487-1) duplicate for 8 times
@umarabdulsattar3275 would you able to provide some expected output records ? It will help us to understand your use-case
Maybe this flow as your want:
Process:
1- Multi-Field Formula: Clear all repeat Field to unique at one cell.
2- Text to Columns: Split combine field [evseId] to rows.
3- Text to Columns: Split combine field [PowerType] to rows.
4- Record ID: Create line ID for Sort.
5- Unique: filter all repeat rows out.
6- Sort: sort by [RecordID] to restore order.
7- Select: Remove field [RecordID].
One way to do this
but will love to see the configuration fo multi row field formula by @flying008
till time find the sol attached
@flying008 Thank you so much. Can you please share workflow. It will helpful for me.
Sorry, due to security policies, I am unable to upload the workflow document. Please try following the above post instructions yourself.