I have a consoldiated CSV as below and would want to split files based on criteria when the Row value is "Amount" AmountSportYear 1000NBA2022 TeamAmountYearOwner Chicago Bulls1002022A Indiana Pacers9002022B AmountSportYear 5000UEFA2022 TeamAmount YearOwner Real Madrid50002022

Splitting File - Based on Criteria

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

Workflow

Common Use Cases

Accepted answers

aatalai

@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

Splitting File - Based on Criteria v2.yxmd

All comments

aatalai

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

Splitting File - Based on Criteria.yxmd

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

Splitting File - Based on Criteria v2.yxmd

Punit_Kapadia

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703