Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Join component not working as expected

RogerioReisBR
6 - Meteoroid

Hi gurus!

I am encountering a quite bizarre error with the join component here as follows:

 on the left I have the following columns:

 

Pedido (Order)TKNUM (Transport #) [type VWString 10]other columns
0201875810057002137645645
0201875342057002122234232

a lot of more records

 

On the right I have the following collumns

 

 TKNUM (Transport #) [type VWString 10]EXIT2 (some information about transport)
0570021376MARCADO 09/28
0570023242MARCADO 03/22

a lot more records

 

The particular area of the flow with the bizarre behavior is like below. No big deal, 

 

RogerioReisBR_0-1632754040241.png

I even put some data cleaning components before to make sure the columns are properly trimmed.

 

The join is made by the TKNUM column as shown below and both are the same datatype

RogerioReisBR_1-1632754441225.png

 

 

This basic flow works with a lot of records, but a particular order (Pedido) 0201875810/ TKnum 0570021376, it does not work as expected. Let me show you. On the left the record with this order exists before the join

 

RogerioReisBR_2-1632754616029.png

 and on the same line, it has the TKNUM 0570021376

RogerioReisBR_3-1632754675034.png

Now, on the right, if I search for this TKNUM 0570021376, it exists.

 

RogerioReisBR_4-1632754941373.png

 

But when I search for either the Order (pedido) or the transport # (TKNUM) on the join exit, it does not show as a match

 

RogerioReisBR_5-1632755307073.png

 

Now, here is where it gets better. If I add a filter on the right, filtering only this TKNUM as below:

RogerioReisBR_6-1632755380125.png

 

and execute the flow and search for this TKNUM on the JOIN part of it....guess what? It appears.

 

RogerioReisBR_7-1632755448398.png

RogerioReisBR_8-1632755467052.png

 

Even if I try to add a union after the filter (to get all the results), that particular TKNUM stops appearing.

 

RogerioReisBR_9-1632755714784.png

 

RogerioReisBR_10-1632755786414.png

 

and even more bizarre. The record does not appear in ANY of the exists of the join component (Neither J,L,R)....it just disappears.

 

 

Has anyone ever faced such issue??

 

Thanks a lot.

Rogerio

 

 

 

 

 

 

 

 

 

 

 

 

 

4 REPLIES 4
apathetichell
18 - Pollux

Maybe it's because your browse tool is showing only partial results. Put the filter after the join anchor and see if its there. Try that instead of searching the browse window.

Garabujo7
Alteryx
Alteryx

Oi @RogerioReisBR ,


Bom dia. O que eu apercibo no seu fluxo é que você está olhando apenas resultados parciais.

Isso quer dizer que não são todos or registros.

 

 

Garabujo7_0-1632758449387.png

 

A solução como @apathetichell diz que você precisar de um browse depois da saída J para que consiga olhar os registros todos.

 

You are seeing only partial results as in the image, you'll need to add a browse tool to be able to see all the records coming through,

 

Gabriel

 

RogerioReisBR
6 - Meteoroid

Boa tarde!

 

Exatamente. Foi uma falha minha a nao reparar isso. A Resposta de @apathetichell estava correta e já assinalei como tal.

 

Muito obrigado!

 

 

Good afternoon.

 

Precisely. It was my fault not to notice that. @apathetichell 's answer was correct and it was propperly flagged as so.

 

Thank you very very much!

RogerioReisBR
6 - Meteoroid

Thank you so very much! I can´t believe I did not notice that. Thanks!!

Labels