I am trying to dynamically create new rows from a column that has a range of values (e.g. 0100 - 0199).
I am looking to create a row for each value (0100, 0101, 0102, etc.)
Category CodeCategory NameSIC Code
1 | Agric Agriculture | 0100-0199 |
1 | Agric Agriculture | 0200-0299 |
1 | Agric Agriculture | 0700-0799 |
1 | Agric Agriculture | 0910-0919 |
1 | Agric Agriculture | 2048-2048 |
2 | Food Food Products | 2000-2009 |
2 | Food Food Products | 2010-2019 |
2 | Food Food Products | 2020-2029 |
2 | Food Food Products | 2030-2039 |
2 | Food Food Products | 2040-2046 |
I have attached the entire file for reference as well.
Thanks,
Solved! Go to Solution.
Hi @wvanbus93,
I think this is what you're trying to achieve, i've used the generate rows tool.
If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.
Regards,
Jonathan