Doesn't match item code in Modeler

Minsuk Choi · 2025-04-29T00:21:40+00:00

There was an error rendering this rich post.

Hello,

I'm trying to use item code as join key, but I'm not getting a match.

The table on the left(Table1) is the one I use on my local DB with Enterprise connector,

and the table on the right(Table2) is the one I uploaded from LN to Datalake.

The item codes in the local DB don't seem to have any spaces in them, is there anything else that could be causing this?

Thanks.

Find more posts tagged with

Accepted answers

chris_hunt

It's probably the spaces. You could script a version of your LN table (looks like tcibd001?) and trim the item code, then join the script to your local DB-sourced table. Or, I suppose add nine spaces in front of your local table's item code in a script and then join. I like the first option much better.

Chris H

All comments

chris_hunt

Chris H

Minsuk Choi

The Problem is whitespace from ln_tcibd001.

I shared this problem infor customer service and they found that.

Solution is to trim the item code and connect it to the query-based object in Modeler.

Thank you for your help!