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
20 - Arcturus

@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
20 - Arcturus

@Jaganmohan Updated workflow attached

binuacs_0-1682978662222.png

 

Jaganmohan
8 - Asteroid

hi @binuacs 

Thanks a lot.

Labels