Most Useful Macros to You?

[alexnajm]

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

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

[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 !