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

Question

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 Answer

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/td-p/73203

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

Does this work for you?

Best regards

Phil

paullimCH · Accepted Answer

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-render-tool/td-p/570288

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