community
cancel
Showing results for 
Search instead for 
Did you mean: 

New York City, NY

Welcome to the Alteryx New York City User Group! Please join us in sharing experiences and knowledge.

NYC Alteryx User Group Leaders

Brittany Brannon, SlalomSeth Moskowitz, InterpublicKacper Ksieski, Cleartelligence

Welcome & Guidelines

Find tips to make the most of your User Group experience.

LEARN MORE
Reply
This is an open group. Sign in and click the "Join Group" button to become a group member and start posting.
Highlighted

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

Alteryx Partner

 

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. 

NYC AUG.jpg

 

 

 

10 REPLIES 10
Alteryx Partner

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

Alteryx Alumni (Retired)

hey there!

 

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

 

-garth

Meteoroid

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

 

That would be very helpful!

Alteryx Partner

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 :). 

Bolide

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

Bolide

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

Asteroid

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...

Bolide

@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

Alteryx Alumni (Retired)

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