Most Useful Macros to You?

Hello Community! I wanted to start a discussion about the macros that are most useful in your day to day work.

I'll start - the Text to Unknown Columns macro! This can parse through value as many times as needed for COLUMNS (otherwise you're stuck with doing rows and manipulating afterwards).

Macros

Accepted answers

All comments

Raj

A macro which is used to read the data from all the sheets if syntax is not same in all the sheets.

ChrisTX

Excel output - Write different formats to multiple Sheets in one Excel file

SQL Join: enable users to conduct flexible, SQL-like joins within Alteryx Designer. Users can provide any join condition that satisfies the syntax and operability of the database to which they are connecting and the macro will return the left, inner and right join products of their two tables.

apathetichell

Write to Databricks. This is an incredibly straight forward macro but it allows me to work around Datastream In's limitation that you can't take table name directly from a field.

also - good discussion topic @alexnajm

Qiu

@alexnajm
Nice topic.
I like this one.
Import multiple sheets from multiple Excels with different schema.

Thumb up for @mceleavey
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Import-Multiple-sheets-in-from-one-Excel-file/td-p/840836

mceleavey

Cheers @Qiu !

mceleavey

@Ladarthure wrote a brilliant tool to move lines around. I call it L'Arthur...

flying008

Hi, @mceleavey

Could you please tell me, where is the download link of brilliant tool to move lines around by @Ladarthure ? thanks !

Ladarthure

@flying008 here is a link to the macro!

@mceleavey thank's for the heads up, even if it broke the obscura rule!

https://community.alteryx.com/t5/Community-Gallery/Move-things-around/ta-p/1222549

To be fair, I have a few other macros that are usefull in my dayly life, most of the time around normalizing columns (both names and metadata) before pushing to databases and also the classic batch macro to read multiple files!

flying008

Hi, @Ladarthure @mceleavey

Thank you both ! I got it !

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703