Incomplete Power Query

[Pobek]

Hello,

I have a Power query to manipulate two files. A cashflow file called the 203 (with a primary key called CUSIP) and the Market file called the 402 with both the primary CUSIP and another desired key called the ISIN. I need the 203 file out but with the ISIN not the CUSIP. I have created the query the problem is that the ISIN is only populated for only 1600+ rows n a 4000 row file. What gives?

 

[johnny51981]

That would indicate that only 1600 records on the File 402 have a CUSIP that exactly matches to a CUSIP on File 203. Not knowing what a CUSIP is comprised of, Power Query is specific and exact, including case sensitive...unless you use the Fuzzy options. So if you believe there to be more matches that can be achieved, it is best to do the same clean up work on the CUSIP on both Files 203 and 402, and then have a look at your merged results.