Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

Interface tools with output file name as Date Range - with different sheets in output file

Jaganmohan
8 - Asteroid

Hi,
I am unable to fulfill  below logic - could you please help me out  by providing solution.

I need to fulfill three requirements in one output file.

For example : I am attaching input and required output file for your reference.

Requirement 1: User need to extract the data by using Interface tool (Date Range Filters ) - in my example i.e : 04012023 to 04252023.

Requirement 2: The same Date range need to be present in the Output file name. Example: Output Report 04012023-04252023.xls
Requirement3: and the tool need to generate different tabs (Green,red,yellow) same like provided output along with Summary tab .
and all output sheets need to be overwrite on each run.

 

I am attaching input and output files for your reference. 
Note : I am using 2021.4 version to built the workflow - Thanks in advance.

 

 

Jaganmohan_3-1682958315916.png

 

I am attaching input and output files for your reference. 
Note : I am using 2021.4 version to built the workflow - Thanks in advance.

 

 

 

 

4 REPLIES 4
binuacs
21 - Polaris

@Jaganmohan One way of doing this

binuacs_0-1682961019698.png

 

Jaganmohan
8 - Asteroid

Hi @binuacs 
Thanks for your support - I am done with this thing but it is not fulfilling  my 3 rd requirement 
i.e - need to create different sheets along with Summary tab same as like my shared output.
Need all requirements in single output, Thanks.


Jaganmohan_0-1682962593665.png

 

binuacs
21 - Polaris

@Jaganmohan Updated workflow attached

binuacs_0-1682978662222.png

 

Jaganmohan
8 - Asteroid

hi @binuacs 

Thanks a lot.

Labels
Top Solution Authors