ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Need help with the workflow

c20091929
6 - Meteoroid

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:

c20091929_1-1617212280948.png

 

 

 

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

 

c20091929_0-1617212175162.png

 

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
16 - Nebula
16 - Nebula

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.

patrick_digan_0-1617707456105.png

 

c20091929
6 - Meteoroid

It works well!!!

Thank you so much for your help!

Labels