IF Condition

RajNadar Member

July 2022 in Magic ETL

Beast mode calculation needed..

If 'Model' value contains blank then ignore those column of data and take of rest of rows

model

example

1 20

2 --- blank

3 40

here we need to ignore 2nd rows

0

Best Answer

• 

  GrantSmith Coach

  July 2022 Answer ✓

  CASE WHEN `model` IS NULL THEN 'Ignore' ELSE 'Include' END
  

  You can then take that beast mode and filter it on your card for Include

  **Was this post helpful? Click Agree or Like below**
  **Did this solve your problem? Accept it as a solution!**

  0

Answers

• 

  MichelleH Coach

  July 2022

  @RajNadar It sounds like you need a CASE statement. You can read more about how these work in this Knowledge Base article: https://domohelp.domo.com/hc/en-us/articles/360043429933-Beast-Mode-Functions-Reference-Guide#2.3.

  1
• 

  Ashleigh Coach

  July 2022

  @RajNadar

  case

  when Model is null then 'Ignore'

  else 'Keep'

  end

  Then you can filter on Keep

  
  

  Alternatively, you could also do

  ifnull(Model, 'Blank')

  then filter out Blank

  **If this answer solved your problem be sure to like it and accept it as a solution!

  1
• 

  GrantSmith Coach

  July 2022 Answer ✓

  CASE WHEN `model` IS NULL THEN 'Ignore' ELSE 'Include' END
  

  You can then take that beast mode and filter it on your card for Include

  **Was this post helpful? Click Agree or Like below**
  **Did this solve your problem? Accept it as a solution!**

  0
• 

  RajNadar Member

  July 2022

  Thanks

  0