Free Trial

Forum - Deutsch

Suchen Sie nach Antworten, stellen Sie Fragen und teilen Sie Ihr Alteryx-Wissen.
GELÖST

Daily append to local excel file

Pascal_R
Asteroid

Hi all,

 

Please see attached file. I like to know how I can append daily specific data in a local file.

 

Regards,

Pascal

 

3 ANTWORTEN 3
grossal
15 - Aurora
15 - Aurora

Hi @Pascal_R 

 

I attached a sample solution to your problem.

 

You can do this by simply using the "output tool".

grossal_2-1581528189559.png

 

 

Sample Data via Text Input Tool

grossal_0-1581527943213.png

 

Output Tool Configuration:

grossal_1-1581528005478.png

 

The key is here to choose the option "Append to Existing Sheet".

 

One important thing to know, you don't have to put the same Field names, you can also select "Custom" and map whatever column in your output to an Excel column.

 

The whole workflow is attached. If this solves your problem, feel free to click "accept solution" if this solved your problem or drop a question and let me know how I can further help.

 

Alex

Pascal_R
Asteroid

Thank you Alex!

 

I did below adjustment and it works now.

 

Kind regards,

Pascal

grossal
15 - Aurora
15 - Aurora

You are welcome!

 

Could you accept the previous post as 'solution'? Solutions get highlighted, this helps other to find solutions quicker.

Beschriftungen