May 2018 NYC Alteryx User Group : Technical Session : Macros!

[b_b]

https://www.eventbrite.com/e/nyc-alteryx-user-group-may-2018-technical-session-tickets-45502888364

Hello Alteryx Friends! The next AUG will be on May 8th at Slalom Consulting. RSVP here.

Agenda is as follows:

• 6:00 : Welcome and mingling
• 6:10 : Macros 101 (Seth Moskowitz - Interpublic) : Presentation & Questions
• 6:35 : Regex Macros (Kacper Ksieski - Keyrus) : Presentation & Questions
• 7:00 : Open floor Macro Show and Tell (You!)
• 7:30 : Closing

We hope to see you there! Please post here if you have questions.

PS - we will be hosting an informal happy hour session once a quarter in addition to the technical sessions. The informal happy hour will be held after Inspire in hopes of carrying on the conference's good vibes. 

[b_b]

Hello All,

Looking forward to seeing you tonight! We will start around 6. Feel free to come by a little earlier to hang out and grab a slice.

Please call me at 319.231.8527 if you have issues getting inside.

PS - I have ordered pizza!

Thank you,

Britt

[GarthM]

hey there!

i'm going to try my best to attend tonight. looking forward to the presentations!!

-garth

[attardc1]

Will the presentation be available online if we are unable make it in time?

That would be very helpful!

[b_b]

Hi! We won't be filming the presentations, and it will be up to the presenters on if they want to distribute their content.

If they're fine with sharing slides and (if non-sensitive work data) workflows, we will post them here. 

Thank you! Hope you can make it :). 

[smoskowitz]

Hello --

Thak you for the question. Due to sensitivity issues, I won't be posting the slides online. I am more the happy discuss any questions you might have though.

Seth

[smoskowitz]

Hi All --

Attached you find my PowerPoint presentation along with the Workflow and Macro I demonstrated during our AUG on May 8th.

As an FYI, the workflow does not use any relative paths, so you will need to adjust to meet your needs. The macro also looks for a file called Clean 1.xlsx -- so you might need to create it.

Please let me know if you have any questions.

Seth

[Kdpalmer]

Hi @smoskowitz and team -- Here is another use case for macros, to load in excel sheets in an excel document which have different schemas (format).  The dynamic input tool is most useful on sheets that have identifical schemas (e.g. data by month which each tab representing a month)

Kate

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Read-in-Multiple-Excel-Files-with-Multiple-T...

[smoskowitz]

@Kdpalmer

Thank you for posting this Kate!

At the conference, they showed an example of using a macro to dynamically update formula's. Not only is this a great macro, but its actually a macro inside a macro. I attached what we used in class so you all can have a look.

Looking forward to the next conference in Nashville as well as our next AUG meeting.

Thanks,

Seth

[GarthM]

if you're curious about complex macros (i.e., macros w/ nested macros) have a look at this one:

C:\Program Files\Alteryx\bin\RuntimeData\Macros\Google_Analytics_v6.yxmc

The macro author is a real j3rk but there's a fair amount to be learned from looking under the hood of that thing. ;p