Alteryx Designer Desktop Discussions

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

output act as a input tool for the Append Suffix to file/ Table Name.

Sarreddy
9 - Comet

Hello Team,

 

I need a some clarification on output tool.

 

 I have a passed file name and path and sheet names by using formula tool. Based on that I have a changed my output file path by using in change Entire file Path in output tool. 

But in my case I would like to create a output like based on the field values in each tab from the output from change Entire file Path.

 

 

 

Sarreddy_0-1669808948719.png

 

 

Sarreddy_1-1669809148545.png

 

3 REPLIES 3
Felipe_Ribeir0
16 - Nebula

Hi @Sarreddy 

 

If i understood well, you want 1 tab for each ReportName, right?

 

Felipe_Ribeir0_0-1669810351805.png

 

You can do this using the ReportName column as a variable inside of your Tab_name formula:

 

Felipe_Ribeir0_1-1669810388664.png

 

Take a look at the attached workflow.

 

 

Sarreddy
9 - Comet

@Felipe_Ribeir0  

Yes exactly that is my expected output. Could you please explain what and all changes you have done in my workflow.

Thanks a lot for the your response.

 

Regards,

-Ajith Reddy  

Felipe_Ribeir0
16 - Nebula

Hi @Sarreddy 

 

Change your output tool and your formula tool from "BEFORE" to "NOW" like this:

Felipe_Ribeir0_0-1669811525844.png

 

Labels