Alteryx Designer Desktop Discussions

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

Loop query based on each row

HeadBanger
Astéroïde

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 RÉPONSES 10
jamshed23
Météoroïde

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 

 

Étiquettes