Analytic App instead Macro, load data with the File Browse Tool instead Macro Input?

Hi!

I have build a macro. Outside the macro (in a workflow) I connected the macro input with a Input Data Tool (Test Input Tool or so) to an external data source like a csv-files.

Inside the macro I work with the incomming data and the data are going outside with a Macro Output Tool.

When I will run this functional in th Alteryx-Gallery it is not possible. Because I can't execute macros in the Alteryx Gallery.

So I have to build an Analytic-App instead.

But how is it possible to read the data from the a external data source with a File Browse Tool, work with incomming data inside the Analytic App. And get the same functionality like like my build macro?.

For example my build macro:

And the workflow:

Mathias

examplemas.yxzp

Macros

Best Practices

Apps

Preparation

Accepted answers

DultonM

Hi @mathias_schnoor!

Hopefully I can help! As you mentioned, the File Browse is what you need. To replicate what your macro is doing, you just need to utilize the File Browse with Drop Downs! Here's an overview of the process:

1) Start by creating a workflow that does what you need with an example data file; use an actual Input tool.

2) Connect a File Browse tool to the Input tool. An Action tool will automatically appear with the correct configuration "Update Input Data Tool"

3) Connect 3 Drop Downs to the File Browse (one for A, B, and C). When you connect a Drop Down to a File Browse, the drop down will automatically populate with a list of fields from the file you select with the File Browse.

4) Connect each drop down to the Formula tool where you are performing your concatenation. One option is to connect via Action tools and change the specific string in the formula tool. Caution though: when connecting multiple interface tools to an ordinary tool, order matters. If your first Action tool replaces part of the formula expression with a value that the second Action tool is set to replace, you may not get the expected results. (you can see what I mean if you choose B, A, then C in the app I've attached (you may need to relink to the sample spreadsheet I used)).

To summarize, the File Browse changes the input tool to bring in the data from a file of your choosing. The drop downs update with a list of fields from that file. The drop down selections then change the formula tool to ensure concatenation occurs on the appropriate fields.

I have attached an app that should bring to life what I shared above. Hope this helps! Let me know if you have any questions!

Book1.xlsx

File Browse with Drop Downs.yxwz

All comments

DultonM

Hi @mathias_schnoor!

1) Start by creating a workflow that does what you need with an example data file; use an actual Input tool.

2) Connect a File Browse tool to the Input tool. An Action tool will automatically appear with the correct configuration "Update Input Data Tool"

I have attached an app that should bring to life what I shared above. Hope this helps! Let me know if you have any questions!

Book1.xlsx

File Browse with Drop Downs.yxwz

mathias_schnoor

Hi @DultonM

Thanks a lot of your support. I have test your solution. I works with Excel *.xlsx fine. When I use a database connection too.

But what when I use an input data like csv-format.

It does not match why?

Do you have a solution?

Mathias

File Browse with Drop Downs_MAS.yxwz

testinput2.csv

NancyS

Hi Bolide, I'm having problem at step no. 4. Can you elaborate? I am using a "Select Tool" where 3 inputs from interface tools are connected. The Action Type has been selected as "Update select with multi-select ListBox". Have used 2 List Box and 1 Drop Down.

Problem I'm facing:

Input File has these fields: Field1,Field2,Field3,Field4,

For List Box 1: Field1,

For List Box 2: Field 3

For Dropdown: Field2

Output in Results: Field 1,Field2,Field3,Field4

Required Output: Field1,Field2,Field3

Please guide.

TIA!

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167