Magic ETL

Magic ETL

etl issues

CASE
WHEN "SUBSCRIBERS" < 10000 AND "Youtube engagement rate" >= 3 THEN "Micro_HighEngagement"
WHEN "SUBSCRIBERS" < 10000 AND "Youtube engagement rate" >= 1 AND "Youtube engagement rate" < 3 THEN "Micro_MediumEngagement"
ELSE "Micro_LowEngagement"
END

it is failing and saying column not found , how to resolve this , please hepl

Best Answer

  • Answer ✓

    Are you using Magic ETL? If so, the full quotation marks " are your problem. Instead, just start typing the column name without any quotation marks and then select it from the auto-complete list. Domo uses single back ticks ` if you wanted to try and manually type it, but it is much easier to start typing the name and select it from the auto-complete list.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • Answer ✓

    Are you using Magic ETL? If so, the full quotation marks " are your problem. Instead, just start typing the column name without any quotation marks and then select it from the auto-complete list. Domo uses single back ticks ` if you wanted to try and manually type it, but it is much easier to start typing the name and select it from the auto-complete list.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In