Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to execute Alteryx workflow with limited rows

nisarghande
6 - Meteoroid

I have below the Columns which is DateFrom and DateUpto, We are loading historical data through the api, API have some limitations, I wanted to call apis by monthly basis, We have parrameter for api which is Datefrom and DateUpto, I have Values for 2 years, wanted to pass this values in chunk, how I can break this table through Alteryx and forward the values in sequence for

 

 

DateFrom DateUpto DateMonth
2018-01-01 2018-01-07 1
2018-01-08 2018-01-14 1
2018-01-15 2018-01-21 1
2018-01-22 2018-01-28 1

 

2018-01-29 2018-02-04 2
2018-02-05 2018-02-11 2
2018-02-12 2018-02-18 2
2018-02-19 2018-02-25 2

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @nisarghande 

 

Just want to confirm when you say API you are using the download tool right.

atcodedog05
22 - Nova
22 - Nova

Hi @nisarghande 

 

Here is how you can do it.

 

Workflow:

atcodedog05_0-1630998919228.png

 

Each row can be converted to API url with parameters. This way each row is an URL endpoint for a chunk of data that will be fetched.

 

Hope this helps : )

atcodedog05
22 - Nova
22 - Nova

Hi @nisarghande 

 

Or you can also follow batch macro method. Here are some resources on it.

 

https://community.alteryx.com/t5/Interactive-Lessons/Creating-a-Batch-Macro/ta-p/657923

https://community.alteryx.com/t5/Videos/Build-Your-First-Batch-Macro/td-p/52900

 

Hope this helps : )

 

 

Labels
Top Solution Authors