Alteryx Designer Desktop Discussions

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

Loop query based on each row

HeadBanger
8 - Asteroid

Good day,

 

I'm trying to query a database to look up SKU metrics during a time period that I'm targeting for each SKU.  

The problem we have is that there are 8000 different SKU / Date Range combinations.  

 

I'm thinking a batch macro might solve this but i'm only guessing.  Not even sure where to begin?  

 

Let me know if anyone has ever looked worked on something similar that could solve this challenge

 

Thanks for your time.

Sam

10 REPLIES 10
jamshed23
6 - Meteoroid

Dear mbarone ,

I have very big table, it's has more than 20 millions record, i need to fetch data, transfer and migrated to another database table. Load all at once and than migrate not possible. Does alteryx has FOR EACH LOOP like concept as it was SSIS ? something that split load 

 

Labels