Parsing Data File

[mchatrvd]

Hi

I have a source file that has data in the following format -

Store1 - Summary - SKU1, SKU2, SKU3

Store1 - Details - 100, 200, 300

Store2 - Summary - SKU3, SKU2, SKU1

Store2 - Details - 600, 500, 300

Store3 - Summary - SKU2, SKU3, SKU1

Store4 - Details - 300, 200, 100

I will like to parse this data into a tabular format like this -

Store    SKU1    SKU2     SKU3

Store1  100        200        300

Store2   300       500        600

Store3  100        300        200

Please advise. Thanks in advance.

[JosephSerpis · Accepted solution]

Hi @mchatrvd I mocked up a workflow let me know what you think?

[echuong1]

You can parse with the text to columns and then filter out the additional headers.

[atcodedog05 · Accepted solution]

Hi @mchatrvd ,

Here is a workflow for the task

Input:

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[atcodedog05]

Happy to help 🙂

Cheers and happy analyzing 😀