Alteryx Designer Discussions

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

Output tool

anupgupta12
8 - Asteroid

Hi There!

 

I am trying to get output of workflow into input file, the input excel file already has 2-3 Sheets, but when I use the same file for output the already exist sheets are removed and only output sheets are available. How do I make sure that my output file does not remove the sheet which already exists.

5 REPLIES 5
Emil_Kos
16 - Nebula

Hi @anupgupta12,

 

Does your output have this configuration as a set-up?

 

Emil_Kos_0-1622553795611.png

 

anupgupta12
8 - Asteroid

Yes, I  have tried "Create new Sheet" "overwrite" and "Append to existing sheets". None of them is working for me.

 

For eample

 

Input file has

 

input sheet 1     input sheet 2

 

but output file has

 

output sheet 1 output sheet 2 

 

but it does not have input 1 and 2

 

 

Emil_Kos
16 - Nebula
anupgupta12
8 - Asteroid

Do you know if Alteryx reads macro enabled excel file?

T_Willins
13 - Pulsar
13 - Pulsar

HI @anupgupta12,

 

Yes, Alteryx can read .xlsm (Excel Macro Enabled) files.  It does not read the macros; it brings in data similar to a standard Excel (.xlsx) file.

Labels