Macros

[Shrik]

Hey all

I am trying to figure out how I cam wrap up an Alteryx workflow (see workflow in container) and wrap the whole workflow into a macro.

So I use 1 icon (batch macro) and insert this into the data source.And it does the full ETL process, as opposed to have 13 icons

I am not sure if Alteryx can even do this. 

But trying to do this as i'm fairly new to Alteryx so fairly difficult getting my head around this.

Also see attached my workflow I have now - any suggestions please help.

Many thanks all.

Shrik

  

 

[JoeS]

Hi @Shrik 

I converted the dynamic input to a standard one. Then looked to add a control parameter and action to update that from the directory tool.

Finally I added a macro output tool to the end, and that should be the batch macro that you need:

Let me know if you have any further questions (or that it doesn't work as I didn't have the data to test).

[Shrik]

Hey @JoeS 

Yes i think this looks fine 

I am trying to test it out - how can i add the macro icon to the 2nd screen shot you see?

So ideally i am trying to get my workflow to be linked from 

"Data Source (folder of CSV's Files">>>>>>>>>>>>>>>>Straight into Macro Icon

Thanks for the fast response on this as well

  

[JoeS]

You're welcome.

You can insert a macro by: Right Clicking on the Canvas > Insert > Macro > Browse to your macro.

You'll then just need to pass in the FullPath from your directory tool.

[Shrik]

Thanks @JoeS 

Seriouly im loving Alteryx!

Still getting my head around it - so im doing the videos while practicing on my own datasets! 

But thanks big help!

[JoeS]

Great stuff. Glad you are liking it, and that I can help!

[Shrik]

Hey @JoeS and all

Just curious, my macro works fine. 

Just wondered why is it when i add in my "File Name" columne inside the macro, 

And after adding in my macro on the actual data source i see a schema error?

First 2 screen shots look good 

Last 2 screen show me the errors when i edit and add in my "File Name"

See attachment if needed

Thanks in advance. Just slighly confusing exactly how to debug the error.

    

[JoeS]

Hi @Shrik 

It looks like the formats changing based on the different files.

There is an option in the Interface section of the macro to change the error:

[Shrik]

Hey @JoeS 

How is this done as my screen shows something slightly different.

[Shrik]

Hey @JoeS 

So I am working on a similar process inside Aleryx.

The macros seems to work fine - just not sure where I am going wrong in terms of configuration

1st screen looks fine to me

2nd screen shot is also fine as its doing the ETL for me, just not sure wheres its duplicating the numbers.