OutPut Template File Based on Date

I have template File where two Pivot Tables are created based on Consd sheet

All the new data is inserted into Consd sheet

Expected Output :
For every each run Alteryx should pick data and insert into Consd sheet based on date and create new file

ex: sample_date 23Sep.xlsx with the pivot tables.

I would like to create this using Blob tools only

I have attached sample workflow please look into it.

sample.yxzp

Data Investigation

Accepted answers

binu_acs

@BRRLL99

sample.yxzp

All comments

OTrieger

@BRRLL99
Yes, you are right one way to do it will be with Blob tool. What is the challenge that you are facing to get it done?

BRRLL99

Im Facing 2 Issues :

1. data needs to be inserted into existing sheet Consd, But new sheet is getting created as ConsdC__Users_Admin_Downloads_T

2, Based on date column, date should be added to the new Alteryx file only sample_Template is getting created without date.

OTrieger

I see, the way how Blob tool works is as follow:
Blob Input gets an existing file/template then the Blob output will save that exact file into a selected location, then with the Output Tool you write the data into the specific range indicating that you would like to use the source file formatting, probably you will not need the headers,
So if you want to have a date in the output file it needs to be added to the Blob Output naming path, then when you write the data into the template use the same new name, with date.
If you want to create a new tab for that same sheet, what you will need to do with a Output tool, set the same path with file name, only need to set a new sheet name that will be added to the existing file.

BRRLL99

can you please show it in the workflow, I'm same error

OTrieger

@BRRLL99
When you are using Blob tool you will have to synchronize the output, first Alteryx will need to save the Blob Output and only then save the data into the template, the most easy way to do it with Parallel Block Till Done.

As the data will be insert into the template the date need to be part of the naming of the template
"C:\Users\Admin\Downloads\Template\Outputs\" + "Sample_Template "+ ".xlsx" You need to add for this path:
"C:\Users\Admin\Downloads\Template\Outputs\" + "Sample_Template "+[Date]+ ".xlsx"

Otherwise your template and output will be saved in 2 different files, the template will be ...\Sample_Template.xlsx and you data will be saved in ...\Sample_Template2021-02-01.xlsx (or whatever date and date format your have for your data)

binu_acs

@BRRLL99

sample.yxzp

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703