GrantSmith Coach 
-
Re: Check if site exists in another dataset, then remove from list if exists - ETL
Hi @louiswatson You can do a left join from your existing dataset to your dataset 3 based on the Database Number. If the right table's Database Number is NULL then it doesn't exist in the l…2 -
Re: Hi Team, Need help in converting a string value to date.
What does your function look like? You should be able to do something like this: STR_TO_DATE(`str_field`, '%b-%y')2 -
Re: Case statement not working
Case statements are evaluated from the top down and will stop when they find a condition that's true. Because you have WHEN STR_CONTAINS(AdditionalRecruiter,',') THEN AllRecruiter At t…3 -
Re: Hi Team, Need help in converting a string value to date.
You can use the STR_TO_DATE function in a beast mode or a formula tile in a magic ETL to convert a string to a date based on the format string. Documentation: https://domo-support.domo.com/s/article/…1 -
Re: Fixed Function - More complicated function
You've got a few too many closing parenthesis and aggregate functions. Are you wanting the filter none to apply to the engagements AND the page views or just the page views? Try something like t…2
