Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Combining Daily snapshot Data - Upto 30 Days

suby
11 - Bolide

All,

 


We have a Daily Data which comes as an excel workbook with Multiple sheets say around (70) sheets and in every 3 months
there will be changes to the Data structure by adding in new columns or renaming existing columns.

 

Say if i have the Data file from January 1 2023 until JANUARY 31 2023.

 

Is there a better solution to combine all the Data file from Jan 1 to Jan 31st across all the sheets and produce a output
data.

 

If it can be done what would be the Output Data format like can it be done on .yxdb or ,hyper file or any other output file format.

Will there be performance issues ?

 

Is there a workflow out there that i i can use as a starting point to achieve the above.

 

Thanks

 

1 REPLY 1
Felipe_Ribeir0
16 - Nebula

Hi @suby 

 

I believe that you can use the batch input macro to do that. Check the attached example.

 

Felipe_Ribeir0_1-1674589545606.png

 

 

Labels