Help: random parts of my lookup aren't pulling through

[EMPMUK]

Hi All, 

I have a big dataset with various inputs and so rely on a large lookup "dictionary" to map everything correctly in appended columns. 

I'm finding that for 5 or so values they aren't pulling through the mapped values from my lookup doc while everything else in the same column is doing so fine. The only thing I can notice is that they use special characters like umlauts and accents and the column is set to v_wstring but I can't see why this would cause an issue, the values are hard pasted into the lookup doc for mapping so special characters should also be there. 

Any advice would be hugely appreciated. 

Thanks, 

EM

[FinnCharlton]

Hi @EMPMUK, one tip would be to use the DecomposeUnicodeForMatch() function on values from the dataset and lookup table, then try and join again. This will remove the special characters, which may be bring treated differently in the big dataset to the lookup table.

[TimN]

Hi,

Can you send a data sample?

Thanks