How to split repeating data values from a single column and update in a new book

1

Hi, Requesting help in splitting a file with data which is similar in file A and move the same into file B.

ex: Merchant Data1 Data2
XYZ 1 1
YYZ 1 2
XYZ 2 2

In the above ex: XYZ remains common. I want only this particular row data to be split in a diff file. I have a huge data.Pls help in getting this done.

2

What would be the expected result in the example you provided?

3

Result:

File 1:
Merchant Data1 Data2
XYZ 1 1
XYZ 2 2

File 2:
Merchant Data1 Data2
YYZ 1 2

4

this is what i am expecting

5

Use the “Split delimited text file” action - it does exactly that. In its settings specify that you want to split the file using column “Merchant”.

Alternatively, see Example #2 in the iteration examples in our tutorial on iterations: https://easymorph.com/learn/iterations.html