SOLVED
Loop query based on each row
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
HeadBanger
8 - Asteroid
09-29-2020
08:08 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
Labels:
- Labels:
- Data Investigation
- In Database
- Macros
10 REPLIES 10
jamshed23
6 - Meteoroid
08-03-2023
05:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- « Previous
-
- 1
- 2
- Next »

