GrantSmith Coach 
-
Re: Trimming and converting a Date/Time Field
You can use the HOUR function to return a value between 0 and 23 to filter on (in your case 9-17). CASE WHEN HOUR(`Timestamp`) BETWEEN 9 AND 17 THEN 'Keep' ELSE 'Exclude' END If y…2 -
Re: Building a filter/fxn for ETL to pick the earlier of two dates when applicable?
You can use the LEAST function to select the smallest value of dates LEAST(`Observation Date`, `Admit Date`) If the observation date is null then you'll want to default it to the admit date via …2 -
Re: How can I remove all special characters and spaces from values in a field?
Regular expressions are your friend in this case. You could ignore any non-alphanumeric characters in your string with something like this with a formula tile: REGEXP_REPLACE(`field`, '[^a-zA-Z0…3 -
Re: SQL DataFlow vs API access
The MySQL dataflow runs slower because it must transfer 16MM rows to the MySQL server process it and then transfer the data back. Queuing via the api doesn’t need to transfer the data across systems …1 -
Re: how to split up column based on string of charecters
We don't have the ability to delete the posts but an admin might be able to. I'd recommend leaving them up but posting how you ended up solving your own question so others can also learn wh…1
