Excel data pulling

[moshood]

Hi Community, 

I have a large excel workbook with around 10 tabs of different data within. 

I want to be able to pull to pull a handful of different cells into alteryx in order to join the data.

Can anyone recommend the best way to do this or an efficient way to pull certain cells from different pages. 

Thanks 

[pedrodrfaria]

Hi @moshood 

Probably the best solution since the data is different is to unfortunately use 10 data input tools and manipulate the data so it can be all blended together.

Pedro.

[afv2688]

Hello @moshood ,

Would you be able to share the file with some data? I just need to know the name of the columns and the data type (if you want to replace your actual data is ok)

Regards

[moshood]

Hi there, 

Please see attached. 

in short i would like to pull all of the info on sheet 1 and all of the grand totals from every page there after. 

the models i am working on will be more complicated but this will be an easy way to understand the process. 

thanks 

Mosh 

[clmc9601]

Hi @moshood,

Would something like this work? If your sheets have different schemas, a batch macro could also work. Dynamic input is simpler if all your actual sheets are consistent though!

 

[moshood]

Thank you for sending this over to me.

If I used a macro, to pull all of the tables on each tab is there a way that alteryx would store it efficiently for use? 

For example rather than collect the grand total I wanted to collect and store the tables on each tab and then I wanted it all saved by the file name.  (Bearing in mind that I am going to keep received files in the exact format).

How would alteryx store tabular data from different pages.

Does this make sense? 

Regards

 mosh 

[clmc9601 · Accepted solution]

Hi @moshood,

It depends on your intention storing the individual sheets. I built a sample macro that you can experiment with depending on your intention. If you want to save the individual sheets as yxdb files, the batch macro can help with that. If you just want to read all the sheets on top of each other (and they all have the same schema), the dynamic input will be enough.

I hope this helps!

you can also experiment with output configurationsmacro workflow