Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to input a particular string of text, if its missing

yashs
6 - Meteoroid

Hi!

My data isn't always consistent, and I want it to present the same way every time

My data: 

yashs_0-1606884203300.png

Expected output:

yashs_1-1606884258613.png

Basically, incase the word 'TAF' isn't present, I want to add it there.

 

I have attached the input file incase needed.

 

I'm trying to use the pseudocode

IIF ( 'TAF' not present at location, write TAF, Do nothing)

But I'm not sure how to get the location, and how to write 'TAF' exactly in the same place

 

I would really appreciate your help!

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @yashs 

 

Here is a workflow for the task.

Output:

atcodedog05_0-1606886169898.png

Workflow:

atcodedog05_1-1606886187030.png

Hope this helps 🙂 Feel to ask if you have any questions


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

yashs
6 - Meteoroid

@atcodedog05 

The solution worked perfectly! Thank you so much for the help!

atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂 @yashs 

 

Cheers and Happy Analyzing 😀

 

Feel free to reach out if you face any issues 🙂

Labels
Top Solution Authors