Replacing string

[Feras95p]

Dear all,

I have attached an excel sheet which contains one column named by Payment Method , what I'm looking for is to have a workflow that create a new column and checking Payment method column and if it's written there any of (Credit card, Apple Pay, Bank transfer) replace it by Online payment and write it in the new column other that these works transfer it to the new column without changing anything.

[DavidP]

Hi @Feras95p,

Here is a workflow that does what you asked.

As you're new to Alteryx, I highly recommend working through the Interactive lessons in the Academy section on the Community. https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons

I found them super useful when I first started out. It really covers all the things you need to know and helps accelerate your learning.

There is also the weekly challenges https://community.alteryx.com/t5/Weekly-Challenge/Weekly-Challenge-Index-amp-Welcome/td-p/48275

This is great practice to sharpen your skills.

Happy Alteryxing and welcome to the Community!

[deviseetharaman · Accepted solution]

Hi @Feras95p 

You can use a Formula tool to achieve this. The formula looks something like this:

if [Payment Method] = 'Credit Card' or [Payment Method] = 'Apple Pay' or [Payment Method] = 'Bank Transfer' then 'Online Payment' else [Payment Method] endif

[deviseetharaman]

You can opt to create a new column or update the existing column.