Best Of
Re: Correcting date format in Magic ETL
@jhester yes, the formula tile in magic ETL gives you beast mode functionality within the ETL. You can overwrite existing columns or create new columns. You can find the formula tile under the utility section on the left side.
I have created a video that walks you through using the tile that you may want to watch.
Re: Filtering data will completely remove blank values
This is how DOMO has handled filtering with null values for awhile now; I can't remember if it was for New ETL or an update after that. I suggest assigning a value for the NULL values using Value Map or Formula in ETL.
CASE WHEN FieldA IS NULL THEN 'Blank' ELSE FieldA END
This should save the data from being deleted by your filter.
a10hall
Re: Filtering data will completely remove blank values
@Christianjmzc @a10hall This is actually normal behavior for SQL. If you tried it in SQL server or MySQL, you would get the same result because in SQL, nulls don't work with logical operators as you'd expect. This Wikipedia entry explains it pretty well:
