Splitting File - Based on Criteria

[Punit_Kapadia]

I have a consoldiated CSV as below and would want to split files based on criteria when the Row value is "Amount"

Amount	Sport	Year
1000	NBA	2022
Team	Amount	Year	Owner
Chicago Bulls	100	2022	A
Indiana Pacers	900	2022	B
Amount	Sport	Year
5000	UEFA	2022
Team	Amount	Year	Owner
Real Madrid	5000	2022

[aatalai]

@Punit_Kapadia take a look at the attached workflow and let me know how you get on

[cpet13]

@Punit_Kapadia this sounds like an iterative macro may be what you want. In essence, you would have it find rows where the word amount is, then take everything below it until the next row that has the word amount.

[aatalai · Accepted solution]

@Punit_Kapadia apologies misunderstood the ask so take a look at the updated workflow to see grouping of data, but building on @cpet13 you might need to use a batch macro for specific group transformations 

[Punit_Kapadia]

Thanks aatali. It works with the record ID. Thanks!