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

angela2018
angela2018
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

Best Answer

  • Valiant
    Valiant Coach
    Answer ✓

    Drop the `Sales Team` = 

     

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

Answers

  • Valiant
    Valiant Coach
    Answer ✓

    Drop the `Sales Team` = 

     

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

    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

  • Valiant
    Valiant Coach

    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?

  • angela2018
    angela2018

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

Categories