Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

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

paullimCH
7 - Meteor

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 

 

 

3 REPLIES 3
PhilippK
Alteryx Alumni (Retired)

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

paullimCH
7 - Meteor

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

 

PhilippK
Alteryx Alumni (Retired)

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

 

Have a great day

Phil

Labels