Creating a new column using Formula in Magic ETL

Isaiah02 · 2024-01-22T19:14:54+00:00

There was an error rendering this rich post.

Hello, I have a dataframe with a column named 'Screening Date' in that column are dates and null values. I want to create a new column called 'Completed' that looks through 'Screening date' and if there is a date in a particular row I want to Write "Yes" in my new column. If the 'Screening date' column is null I want to write "No" in my new column.

I have tried using SQL syntax like Alter table and add column but it doesn't look like all SQL keywords are available.

Find more posts tagged with

SQL

Magic ETL

Formulas

Accepted answers

GrantSmith

You can use a Formula Tile and call your new field 'Completed' and use a CASE statement as your formula:

CASE WHEN `Screening Date` IS NULL THEN 'No' ELSE 'Yes' END

All comments

GrantSmith

You can use a Formula Tile and call your new field 'Completed' and use a CASE statement as your formula:

CASE WHEN `Screening Date` IS NULL THEN 'No' ELSE 'Yes' END

Isaiah02

Thank you!

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of