Split multiple columns value

[umarabdulsattar3275]

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]

@umarabdulsattar3275 have you tried the text-to-columns tool with the option split to rows, 

[umarabdulsattar3275]

@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

[binuacs]

@umarabdulsattar3275 would you able to provide some expected output records ? It will help us to understand your use-case

[umarabdulsattar3275]

@binuacs below I attached screenshot,

[flying008]

Hi, @umarabdulsattar3275 

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].

[Raj]

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 

[umarabdulsattar3275]

@flying008 Thank you so much. Can you please share workflow. It will helpful for me.

[flying008]

Hi, @umarabdulsattar3275 

Sorry, due to security policies, I am unable to upload the workflow document. Please try following the above post instructions yourself.