Incorrect result - Join tool

[LinhNguyen]

Hi,

I’m using the join tool to verify if product sku is in a list and noticed that some skus from the right source that are not in the left source still got into the J output.

I’m not sure if I made a mistake somewhere or what happened here. Could you help me take a look?

Here are the screenshot:

Right source: 2 records with the same sku

Left source: No record was returned when I searched for that sku:

Join result:

Tool configuration:

[fmvizcaino · Accepted solution]

Hi @LinhNguyen ,

I think the problem is that you are trying to filter that value directly in the results tab of the join tool.

The inputs and outputs of a tool shows by standard only a sample of the total data. To check if the value is really there, insert a browse tool before the left input and check if the data is there.

Let me know if that works for you.

Best,

Fernando Vizcaino

[LinhNguyen]

Yes I found it when I added the browse tool.

Thank you!!! @fmvizcaino