Need help with find and replace

I'm working on an assignment for school and I'm lost. The two relevant fields to this are Brand and Model. The incorrect value is "Apechete Crux" it should be "Jackson Crux" I just have no idea how to accomplish this with a formula in Alteryx. I've attached my workflow and the directions to this post. The Alteryx instructions start on page 9. The part I am stuck on is at the top of page 11.

Huskie Motor Company_Fall 2020 Case Instructions.pdf

HMC Cleaned data_Group12.yxzp

Help

Accepted answers

phottovy

Here is the formula I used. I find it easier than a find and replace:

IIF([Brand] == 'Apechete' AND [Model] == 'Crux', 'Jackson', [Brand])

I am basically using a conditional statement to find the combination of "Apechete' and 'Crux' and just updating the "Brand" column. The updated workflow is attached.

HMC Cleaned data_Group12.yxzp

All comments

Qiu

@wbrooksga12
So we will do the homework of yours?😁

1. your input data is missing, can you upload?

2. Try the ReplaceString Function, I think that is the one you are looking for.

phottovy

I wasn't able to load your spreadsheet but here is my attempt without loading it. I assumed that the "Brand" field was the one needing updating.

Here is my formula:

Replace([Brand], 'Apechete Crux', 'Jackson Crux')

Replace Formula.PNG

You can also try uploading a packaged version of your workflow by going to Options>Export Workflow. This will package your excel file with the workflow when you upload it.

wbrooksga12

Hey Qui,

The whole assignment is 15 pages and has tableu, Alytrex and a paper portion but yeah, I'm desperate on this part. lol. I have uploaded a Alytrex file you should be able to open. I'm sorry about that. How does the function work without cell references? I've only used excel.

wbrooksga12

I have uploaded the package in place of the file that wouldn't open. I'm trying this formula now. I'll be back with an answer in just a second.

wbrooksga12

Brand and model are separate fields. I tried the formula you mentioned and it said Formula (11) The field "" is not contained in the record. (Expression #1). I don't get it. Model is definitely a field in the input data.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703