Repository for code snippets

jabrantes

Hi everyone,

I thought a nice feature to have in the Element Community is a repository of code snippets whether it is SQL or REGEX that deals with thing that we run into often.

For example - Dedup is something that is done often but there are different code depending on how you want to dedup.

Another example is writing a regex that removes all special characters from a column.

One more example would be to leverage SQL transformation to feed into a validator so the validator can change color based on a row count. I use this in a lot of places.

I am sure there are many, many more examples that we can share or even improve upon.

Jim

kanyinsa

@jabrantes great suggestion! Here are two threads where community members have been swapping SQL tips:

https://community.elementanalytics.com/discussion/54/looking-for-a-replace-function

https://community.elementanalytics.com/discussion/40/common-sql-queries-in-unify

kanyinsa

@Jessica check out this interesting post from @jabrantes !

juanita

@jabrantes - thanks for your suggestion!