ggenovese Coach 
-
Re: Transforming an ETL
Hello - If you want to take an entire row from one dataset and add it to another then you need to Append rather than Join. If you're concerned about alterations to the existing ETL I would recom…2 -
Re: I need help with my equation
I'm having a little trouble following the logic, it might be helpful if you shared your excel formula. Is the case statement you shared supposed to produce the New Fee A value, and you'll h…1 -
Re: Create Month End Date column with Year & Month columns?
There's a LAST_DAY() Function that gives the last day of the month for a given date: LAST_DAY(STR_TO_DATE(CONCAT(`Year`,`Month`),'%Y%m'))3 -
Re: Top 25s etc. in Table cards
Another option might be to create a beast mode to rank each traveler and then use subtotals to collapse the rows for the travelers whose rank is greater than 25. Assuming you have a field named `Trav…1 -
Re: Any tips on how to clean Typo's in a dataset?
No problem! The REPLACE() function would work inside of either a Magic ETL or in a Beast Mode inside of a card. The function will strip out the pipes "|" and replace with SPACE and strip ou…2
