Automate input file to append daily

Question

Hello.

I am trying to automate daily files that gets dropped into a folder every night as a .txt in a folder and i need to append that to historical data automatically . can you please guide me a sample , I am brand new and do not know how to do that.

Thank you in Advance

johnyli168 · Answer

Hey @mehbpar,

Depending on the schema of the datasets you are working with (I am assuming they are going to be the same) I can suggest having a look at the following community article: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480

I also echo @Qiu's comment above from a true automation front.

mehbpar · Answer

Hello Qiu,

I need to upload daily files on top of each other daily, can u please guide me?

Activity Report - Yesterday-2022-07-22-01-00-30.csv

Activity Report - Yesterday-2022-07-23-01-00-30.csv

Activity Report - Yesterday-2022-07-24-01-00-30.csv

Qiu · Answer

@mehu75 
You need to have Alteryx Server or Scheduler to have this automated working process, and they require seperated licenses other than Designer.

If you are ok with pushing Run button every morning, we can do something about it.