Regarding dynamically appending monthly data in alteryx designer

[PiyushJain]

Hi Team,

Please help me to understand, 

How we can dynamically pick the latest month data for append, in any workflow, in alteryx designer. 

My workflow contains couple of macro connections.

Also For mentioned query,

I followed couple of links..but seems more visibility required.

Please advise.

Regards 

Piyush Jain

[afv2688]

Hello @PiyushJain ,

You can use the directory tool to get all the files that are specific for your project (meaning if the share same name or same extension for example).

After that, using a sort tool you could have them sorted our by date, having the newest on top.

Last part would be to sample then the first row to after that have it inputted directly onto your file by using first the dynamic input and after the output tool.

Regards

[PiyushJain]

Hi,

Thanks for your help.

I will check and try to do the needful. 

Regards 

Piyush J

[PiyushJain]

Hi 

I tried to make the similar flow and able to do that.

But this is not the Solutions i am looking for.

Let me explain my actual project scenario 

1.Data is coming from Database & Feed to Alteryx 

2.Preapred Alteryx workflow for pre- proessing 

2. Currently i have data till Jan2021 ( including historical data).

3.Now i need to  dynamically append data for the month of feb2021 ( till date or say 15 days)

(I means 1st to 15th feb 2021 ).

And i need to dynamically do this append process for every month ( when the data is available for that month) throughout the year. 

Hope i explain my issue properly, still if you have any question, please let me know.

Regards 

Piyush J

[PiyushJain]

Hi Team, 

Please reply..

Regards 

Piyush Jain

[PiyushJain]

Hi Team

Please reply.. 

Regards 

Piyush Jain