Hi I have different 4 (A,B,C,D) Excel Binary worksheets, Each file has 4 DIFFERENT sheets and standard template I would like to insert data in Main sheet only Input : Alteryx generated results window DATATOTALFILE NAME100GH10A100RT20A200TH40B400YY5D For File A: 100GH10100RT20 for file B: 200TH40 for file D: 400YY5 based on the file name from Alteryx, excel files needs to be updated in the pre existing template From cell : B10 to C10

Alteryx Output to existing Excel Template

I have different 4 (A,B,C,D) Excel Binary worksheets, Each file has 4 DIFFERENT sheets and standard template

I would like to insert data in Main sheet only

Input : Alteryx generated results window

DATA	TOTAL	FILE NAME
100GH	10	A
100RT	20	A
200TH	40	B
400YY	5	D

For File A:

100GH	10
100RT	20

for file B:

200TH

for file

400YY

based on the file name from Alteryx, excel files needs to be updated in the pre existing template

From
cell : B10 to C10

Data Investigation

Accepted answers

All comments

Raj

@BRRLL99 you will be breaking this into 3 Pices and then as per template you will be writing for each file name
you will be also using multiple block until done so it does not give any error.

BRRLL99

please how it can be done

since those are existing it will have previously some data,

if i run run the workflow Alteryx should add new data , removing old data.

@usmanbashir @binu_acs

binu_acs

@BRRLL99 I am not following your requirement, can you explain a little bit more what exactly you are looking for?

BRRLL99

Let's take a scenario in a folder I have 4 excel Files (A, B, C, D) which has some previous data from cell A11 to B20

ex: Alteryx has generated results

for file A : it has generated only 5 rows of 2 columns

Since data is already present from A11 to B20, Alteryx should remove old data and add new data

For File C:

Alteryx has not generated any results

then from A11 to B20 cells should be blank

ed_hayter

I do not believe Excel Binary outputs have the capacity to output to a specific range. if you want to write data to a specific area of a template consider using a .xlsx and using a formula tool to write a custom file path writing the files to the same location but each with their unique name then overwriting a sheet name and adding the range after that.

You would want your file path in the formula tool to be crafted as:

Filepath/filename|||'Sheetname to overwrite$A11:B20'

BRRLL99

@ed_hayter @binu_acs

How do I output to an Excel template file? (alteryx.com)

I tried this approach for the binary file , it is giving me expected result the only issue is that headers are creating twice

Before Alteryx run Excel Data:

DATA	COUNT
A	11
B	29
C	40
D	50

After Alteryx run with new data

DATA	COUNT
DATA	COUNT
A	11
B	11
C	11
D	11

ed_hayter

Not fully following where we are at with this issue. When you output from Alteryx what does the data look like - are there two sets of headers or is it only when you send that data to excel and then try and read in the file that the header is duplicated.

If the former then obviously deduplicate the headers in the flow.

If the latter I wonder if where you are outputting two sheet range wise already has headers above - in which case if you increase the sheet range you are writing to by one (e.g. A1:A11 rather than A2:A11) then you should be able to avoid duplicating the headers,

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703