Need help with the workflow

[c20091929]

Hello guys, 

Just want to thank you for all your help and your time. 

I have a question about the data load via Alteryx. 

There are three parts in this excel:

• Total Insolvencies (Line 1 - 44)
• Insolvencies Filed by Consumers (Line 46 - 89)
• Insolvencies Filed by businesses (Line 91 - 134)

Currently, I built a workflow and only loading the Total section for

• Insolvencies Filed by Consumers (Line 87 - Line 89)
• Insolvencies Filed by businesses (Line 132- 134)

Something like this:

Now, I need to include more details in our DB. I need to load all three parts by province.

For example, under Insolvencies Filed by Consumers

Line 48 is Newfoundland and Labrador

I need to load line 49 (Bankruptcies) and line 50 (proposals) into our database and mark those as Newfoundland and Labrador and also mark those as Individual. 

Line 51 is Prince Edward Island

I need to load line 52 (Bankruptcies) and line 53 (proposals) into our database and mark those as Prince Edward Island and also mark those as Individual. 

and I don't want to load line 48 and 51 since those are the rolling up total. 

I need to do this for all the provinces and also for Insolvencies Filed by Businesses.

Please give me some idea about this. 

Thank you

[patrick_digan · Accepted solution]

Hi @c20091929 , see if the attached points you in the right direction. I've used multi-row formulas and assumed that every third row contains the location name.

[c20091929]

It works well!!!

Thank you so much for your help!