Alteryx Designer Discussions

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

Output data to a specific file, specific worksheet, specific table

dsevilimedu
7 - Meteor

Hi all,

I am trying to output data to a specific file, specific worksheet, specific table (Table 2) in this worksheet. I am able to achieve it all except for outputting to the table. 

 

The workflow I have

 

1. Firstly, create multiple copies of the template based on the number of employees in a particular month with employee id as a filename

2. Then, based on employee id, workflow outputs data to each file, goes to a specific worksheet "Data point", and paste that employee data from cell A2 to AE15000. AF2 to AL2 has formulas.

 

I have an issue with step 2. I am trying to have my workflow output data to the table in the excel file.

 

When I used to do it manually, I copy and paste data in excel and it automatically converts (resized) to table, hence, formulas in column AF to AL were working. With workflow, I am able to output but its not within the table, hence formulas in column AF to AL not working.  

 

Also, when I open the file after workflow runs, I am getting an error

 

 

 

 

 

1 REPLY 1
apathetichell
16 - Nebula

you need it in this format:

 

filepath(including excelfilename)|||`[sheetname]:A2:AE15000$`

 

so you have to concatenate [filepath] [sheetname] and [range]  as described above. - then you write to fullpath.

Labels