Alteryx Designer Discussions

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

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

SOLVED

Excel data pulling

moshood
8 - Asteroid

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
12 - Quasar

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
15 - Aurora
15 - Aurora

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
8 - Asteroid

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
11 - Bolide

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!

 

Screen Shot 2021-02-22 at 8.26.39 PM.png 

moshood
8 - Asteroid

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
11 - Bolide

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 configurationsyou can also experiment with output configurationsmacro workflowmacro workflow 

Labels