RobSomers Coach 
-
Re: New nested statement
@kodonnellLT What field is supposed to be greater than 111? You are missing that field, so it should be: case when `Status_c` = 'Booked' and `Field` > 111 then 'Tier 4' else 'Tier 1' end Your last…1 -
Re: Automatic Record Matching - Customers
@kpmwinston Unfortunately, since the Customer Name or Customer Address aren't exactly the same, you won't be able to join them together. In Magic ETL, you could use some formulas to modify names and …1 -
Re: search and replace
@damen What does the data look like? If the field contains things like 'Not Repeat' with not at the beginning, then you could use a formula tile and do: REPLACE('Not ',`Col A`,'Replacement ') --Note …2 -
Re: I'm trying to figure out a beast mode for a card for points?
@ggountanis Points to dollars: 'points' / 10 (ex: for 500 points, 500/10 = $50 Or going from dollars to points: 'dollars' * 10 (ex: for $50, 50*10 = 500 points) You're not really dropping a zero, you…3 -
Re: Magic ETL: How to REMOVE Rows Meeting a Two-Column Criteria?
@pstrauss You would just do the opposite of what you're wanting to remove: column 1 is null and column 2 is not null4
