Grouping customer markets into segments

[LM_APAC2023]

Hi all,

I want to add a segment to my current customer market transactions, by assigning them into overarching customer segments. Adding some exemplary data, as I am very new to Alteryx I was hoping you could guide me which formula / tool to best use here?

Thank you!!

[TheUdbhav]

Hi @LM_APAC2023 ,

I observe that you want a new column "Customer Segment" which should have data before hyphen present in "Customer market" column.
For this you can use "Text to column" tool. I have attached the workflow for your reference!

[LM_APAC2023]

Thank you!

It does work for those customer markets with a separating hyphen. I now have another data set that includes customer market: "Investment Banker" which I want to show as customer segment "professional services". The suggested formula doesn't work for this, is there another tool I could use?

Thanks again!

[TheUdbhav]

To can use formula tool and update the column

IF [Customer Segment]='Investment Banker' THEN 'professional services'
ELSE [Customer Segment] ENDIF

You can add other conditions as well!

Let me know if I can assist you more! 

[LM_APAC2023]

Thank you!

Would I need to use If c then b ELSEIF to add all the following conditions?