Skip to content

    • Magic ETL

    Magic ETL

    How to change/reroute specific values in a field and leave all others the same

    Member
    in Magic ETL

    I have a table card. It shows the amount of deals closed by each sales team. In some cases, sales reps change industry teams. I want to be able to say "If sales manager = Joe Smith, then change team to Retail" but since there are 100 managers, I don't want to go thru and put each one in since the rest of the mappings should remain unchaged... this is what I have so far but I'm getting a syntax error. Can anyone spot what I'm missing here?

     

    CASE
    WHEN `Sales Rep Supervisor` = 'John Smith' then `Sales Team` = 'Retail'
    ELSE `Sales Team` END

    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

    Best Answer

    • Domo Employee
      Answer ✓

      Drop the `Sales Team` = 

       

      1. CASE
        WHEN `Sales Rep Supervisor` = 'John Smith' then 'Retail'
        ELSE `Sales Team` END

    Answers

    • Domo Employee
      Answer ✓

      Drop the `Sales Team` = 

       

      1. CASE
        WHEN `Sales Rep Supervisor` = 'John Smith' then 'Retail'
        ELSE `Sales Team` END
    • Member

      I tried it, but then I lose the manager's name. I need Sales Manager to remain the person's name. The team describes what industry they sell to. So I still need 2 separate fields. I just want to reroute John Smith's reps to Retail instead of Advertising.

       

      so the current columns say 

      Sales Manager: John Smith

      Sales Team: Advertising

       

       

      I need it to say 

      Sales Manager: John Smith

      Sales Team: Retail

       

      but all other managers should keep their current sales teams

    • Domo Employee

      I'm a bit unclear on how you're using the fields. Is this a table chart type? 

       

      The BeastMode I provided will replace the Sales Team field, you should still be using the same Sales Manager field. 

       

      Any chance you could take a screenshot of how you have the fields setup in your card?

    • Member

      Ahh I see what you're saying. It looks likethat worked. Thank you!!

    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

    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

    Quick Links

    Categories