In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Macros- Copy and Pest

Kinetic_analytics
11 - Bolide

I want to create macros.

 

Step 1: Copy data from one report from Cognos extract.

 

Step 2: Pest and append data in a new sheet.

 

This process will run once a week.

 

How can I do that?

 

Do you recommend any other easy solution?

 

Appreciate your help.

Thanks

 

 

4 REPLIES 4
Qiu
21 - Polaris
21 - Polaris

If I understand your intention correctly, we can output the current dataset then read back for next week.

1217-Kinetic_analytics.PNG

Kinetic_analytics
11 - Bolide

Thank you.

Qiu
21 - Polaris
21 - Polaris

@Kinetic_analytics 

Glad to help and would apprecaite you could mark the solution as accept if it helps.

Kinetic_analytics
11 - Bolide

Question:

How can I remove previous data? The new week data will replace the previous week's data.  

Thanks

Labels
Top Solution Authors