Analytic App Output File

Question

Hello,

I've just recently started using Analytic Apps and I've to say I love them, but I've encountered a little problem.

I've an analytic app that executes a macro X times depending on the number of imputs selected, the macro then runs the logic and writes a yxdb file for each imput, all runs smothly but I would want the files written by the macro to appear as outputs when I run the analytic app:

I can always look at the log and open the files I want to review, but it would be awesome if I've that files available as the analytic app outputs.

Analytic app:

Macro:

Miguel Alonso.

MacFresno · Answer

Hello mbarone,

I've tested what you proposes and of course it shows me the file paths written, but I can't open from that windows the files, I already was able to access the files via the output log:

But I would like to have the files to be shown as outputs of the analytic app, select them and open which ones I want to review.

MacFresno · Answer

Hi echuong1!

The problem is that not all files have the same field schema as each one is generated based on external and pre-processed yxdb files loaded dynamically by the macro using the names it takes as input from the analytic app.

It seems the problem is trickier than I thought 😅

mbarone · Answer

Inside your macro, add a formula tool or something that writes the file path. Have it go to a macro output.  Your macro icon within your app will then have an outgoing node.  Connect a browse to that output node and it will union all the file paths and display them to you when you run the app.  Or, output them to a YXDB or XLSX or whatever you like.