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

[paullimCH]

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 

[PhilippK · Accepted solution]

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 · Accepted solution]

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]

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

Have a great day

Phil