Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Sheet manipulation

Polite123
8 - Asteroid

Hi Team,

 

Please help me with the below issue

 

What I did:

I have one input excel file with two sheets A and B.

I have used file browse option to select either A sheet or B sheet.

 

What I want:

A single output excel file with two sheets A and B

While selecting A sheet  in input, A sheet output should come.

While selecting B sheet in input, A sheet data should not change in output and B sheet output should be populated. So both A sheet and  B sheet output should be there.

 

 

Middle processing is not explained.

 

Please suggest at an earliest.

 

Thanks in advance

3 REPLIES 3
messi007
15 - Aurora
15 - Aurora

@Polite123,

 

Please see below how to do that, I added a comments in order to explain 🙂

 

messi007_0-1614672886400.png

 

Attached the workflow,

 

If that solve your need please mark it as solved it will help others.

 

Regards,

Polite123
8 - Asteroid

Hi @messi007 ,

 

I am unable to import the package or download the workflow in my designer

messi007
15 - Aurora
15 - Aurora

@Polite123,

 

Please try the attached workflow.

 

Regards

Labels
Top Solution Authors