Join failing on Left Side

GMI WF-SnagIt.png

I'm joining two inputs - one starts as a .yxdb and the other is a SQL pull against a DB2 Database. There are values pulled in where somevalues have only Integers - e.g. 2720 DED_LBL_CD and others have alphanumeric values - e.g. 2720R

GMI WF-SnagIt #2.png

I've formatted them as String, V-String, V-W String, etc and when I join on the two values some are still falling out on the Left Join even though both values are present on Left and Right, immediately before the Join tool. What do I need to do to get them lined up and fall into the J output where they should be?

GMI WF-SnagIt.png

Join

Accepted answers

JohnJPS

Hi @danilang,

I played around with the data you provided, in the attached workflow. I split the concatenated list, had to remove the single-quotes, and then it joined OK. Perhaps it's the stripping of the quotes that's required? (See attached).

Thanks,

John

JoinQuestion.yxzp

All comments

JohnJPS

If something is only present in L, it goes to the L output, same for something only present in R going to the R output. To combine them all, just follow the Join by a Union and send all 3 Join outputs into the union. :-)

rob_lawson

Thanks @JohnJPS

The problem is that the values, that I'm joining on, ARE present in both right and left inputs but the Join tool is not recognizing that it is present on both sides.

Example:

There is a Deduction Label Code of 2625R (in the Left feed it's listed as Deduction Code - in the Right feed it's listed as DED CODE). The right side is pulling from SQL against our database, and the left side is an ASCII flat file.I've run through Data Cleansing tool and removed leading and trailing spaces, and I can physically see the right side data before the Join tool.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703