I have a flow where I am taking two CSV files (Customers and Products) and splitting the data into an array with field names:
I have an excel sheet that, using the excel list rows present in a table/for each, I am filtering on the 'Customers' data.
In the customer data there is one or more products per line. I'd like to do two things which I am unsure of the best method:
1 - check the customer product against the 'Products' data and take a different action depending on this result
2 - One of these actions where the data is present - transform the customer data so that instead of a line per customer, per product, I have a single customer entry and add columns per product and their associated count
Before
| Company | Product | Count |
| Company a | Product 1 | 50 |
| Company a | Product 2 | 100 |
After
| Company | Product 1 | Product 2 |
| Company a | 50 | 100 |
