Trying to match one vendor id to the other vendor id of the other dataset. I have tried formulas, join, fuzzy match all to no avail. This is through work so the info is no what I show in the photo. I made a similar formatted dataset, left side is the two data fields and the right is how I would like it to look.
this is from my alteryx. the SID and complete vendor id (includes USD on the end for all but the first 6 match) match but the vendor id is just pulling another one from the database. I wish I could share the actual data set. What I need is all the ids to match.
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
