Update Workflow to Analytic App - File Browse & Union Tool

Question

Hello, I'm updating a report to show quarterly data, but the text files and both inputs are monthly (Apr'24, May'24, Jun'24). I'm trying to think of a more seamless way to combine all the text files together, Annuities data and other Sales data altogether, to output all at once.

I tried adding a .txt file to see how it would work, but with text files you have to update the configuration of the Flat file settings every time for each month. This is where I think a File Browse tool could come in at. Does anyone know if that could work, or the logic makes it more difficult because I'm combining 3 .txt files from the beginning, along with over input data files?

Attached is the current workflow, but definitely opened to suggestions on how to improve this workflow.

Alteryx workflow.PNG

wbroughton7 · Answer

Okay thanks! I’ll give that a try with adding 3 separate file browse tools. With file browse tool, I would still need to use a union tool as well right?

When you mention a list box, are you referring to a free tool or directory tool? In your experience, which tool(s) do you think would  make the workflow more elegant to update it from where it’s currently at?

Mathias_Nielsen · Answer

Hi, you can definetely add a file browse tool. You would need three though do as you are only allowed to choose one file per file browse tool.

There are also other ways to choose more files at once, with e.g. a Tree tool or a directory tool. But this first solution will work although not as elegant as choosing the file from a list box

Skærmbillede 2024-08-08 132310.png