Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Andy Uttley, Alteryx ACE, makes music with Alteryx | Math + Music
SOLVED

Send the Visual Layout Report to a dynamically-assigned file folder

Highlighted
6 - Meteoroid

Hello,

I am seeking a solution how to send the HTML output from the Visual Layout tool, to an external drive/folder that is dynamically assigned. 

 

Context is , an external User Interface, API-calls the Alteryx workflow, which passes input data and the input folder location, where the HTML output is to be saved. 

 

I have tried the Output-data and the Render tool, but I don't believe either can accept the file location dynamically.

And the Output-Data does not seem to render the html properly.

 

Can anyone pls advise ?

 

I am using Alteryx Designer 2018.4.3 

 

 

Highlighted
Alteryx
Alteryx

Hi @paullimCH 

 

I would first generate the HTML with the Render tool and save it temporary. 

The next work can take this temporary file and dynamically save it in the final output folder:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-create-a-dynamic-output-folder/...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamic-directory-for-export-path/td-p...

 

Does this work for you?

 

Best regards

Phil

Highlighted
6 - Meteoroid

Many thanks Philipp for the quick response. And the shared links. 

 

The following post also helped.

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamic-output-file-rename-using-rende...

 

In the end , the trick was to use the Render Tool, 'Field to Group On: ' where I used the Field containing the reference to the dynamic folder, which I constructed using the Formula tool. 

 

Specifically the HTML output from the Visual Layout tool , was appended with the Output (Dynamic folder) from the Formula tool, using (Append Fields tool). And connected to the Render tool, where I used the Field to Group on. 

 

Thank you for your suggestions. It was very helpful.

 

Best regards

Paul

 

Highlighted
Alteryx
Alteryx

Hi Paul, I am glad that I could help you!

 

Have a great day

Phil

Labels