Using macro in analytic app

[albert_alaluf]

Hello,

I have a workflow that connects to a database, pulls data, I process and provide the result. So I converted this into analytical app, so it will ask username, password, date etc..... So far so good. The original app is not that simple, the are around 25 different tables I should do the same. All tables will share same inputs.

So here is the my challenge. 

I converted all inputs to dynamic input, so fine.

For around 25 data inputs, I should do this for each item, 1 username, 1 password, 1 id, 3 different date metric, minimum 6 dynamic entry or more depends on the data source. This step is repetitive for each data source. So when something is repetitive, the macros comes to my mind.

I want to convert this (container 12) to a macro

to convert this as analytic app

When I run it, I still want to ask me question to feed the dynamic input.

Any suggestions? Is this possible?

Albert

[AZuc]

@albert_alaluf 

You can create interfaces in you macro to capture usernames and passwords, then add the interfaces for the analytic app and make the action tool update macro questions.

[albert_alaluf]

Thank you @AZuc. Do you have any sample you can provide? Even very simple and easy one.

[AZuc]

I'll do it in a moment

[AZuc · Accepted solution]

@albert_alaluf 

See if it helps you

[albert_alaluf]

Thank you for the example. I will try to implement the logic into my workflow, let's see if it works. 

[AZuc]

If it works, please mark my answer as correct.

[albert_alaluf]

As my understanding, you are just (kinda) replicating the work in analytic application I did and save as macro. So I'm just thinking, this macro output will feed my tables, so it will connect to my dynamic tables as input, in a simple term, I will have around 25 connections only and inside macro I need to simulate the number of questions I have in analytics app. Maybe duplicating the work, but it avoids tens of connections and time. I believe I see your logic and pretty sure it will work with a little bit of work.

Thanks

[AZuc]

Exactly, you'll get external info and need to pass them into the macro. So there's no other way than to duplicate the interfaces