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.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

matching partial fields

LRC
6 - Meteoroid
‎04-28-2021 04:13 PM

Hi,  I haven't been able to find a solution in the community that is what I need, so here I am asking for help. I have a list of Alias ID numbers in the Supplier 5109442 RMS list that are possibly in the Daily TF Data 5109442 list, but in the Daily TF Data list they have could have either an I or T after the number.  I need to find which alias ID numbers from the RMS list are not on the Daily TF list.  Seems like a simple action, but I'm not getting it. 🙂  Thanks,  

Preview file
10 KB
Preview file
15 KB
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
clmc9601
13 - Pulsar
13 - Pulsar
‎04-28-2021 09:22 PM

Hi @LRC,

 

I parsed the Daily TF to keep only the numbers, joined the two tables, and looked at only the left unjoin. Is this what you're going for? I hope it helps!

 

Screen Shot 2021-04-28 at 10.20.27 PM.png 

unjoin VPN LRC.yxzp
Reply
0 Likes
LRC
6 - Meteoroid
‎04-29-2021 05:20 PM

@clmc9601  Hi, and thank you.   I am fairly new and have no experience with parse, so I appreciate the response.  I was able to complete the process with what you provided.  I appreciate your help.  Thanks!!!  Lynn

Reply
GenAI Contest Form
License admin COmmunity Live
Labels
Top Solution Authors
View All