Happy 8th birthday to the Maveryx Community! Take a walk down memory lane in our birthday blog, and don't miss out on the awesome birthday present that all Maveryx Community members get to take advantage of!

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
19 - Altair

@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
19 - Altair

@Jaganmohan Updated workflow attached

binuacs_0-1682978662222.png

 

Jaganmohan
8 - Asteroid

hi @binuacs 

Thanks a lot.


Labels