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 |
0201875810 | 0570021376 | 45645 |
0201875342 | 0570021222 | 34232 |
a lot of more records
On the right I have the following collumns
TKNUM (Transport #) [type VWString 10] | EXIT2 (some information about transport) |
0570021376 | MARCADO 09/28 |
0570023242 | MARCADO 03/22 |
a lot more records
The particular area of the flow with the bizarre behavior is like below. No big deal,
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
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
and on the same line, it has the TKNUM 0570021376
Now, on the right, if I search for this TKNUM 0570021376, it exists.
But when I search for either the Order (pedido) or the transport # (TKNUM) on the join exit, it does not show as a match
Now, here is where it gets better. If I add a filter on the right, filtering only this TKNUM as below:
and execute the flow and search for this TKNUM on the JOIN part of it....guess what? It appears.
Even if I try to add a union after the filter (to get all the results), that particular TKNUM stops appearing.
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
Solved! Go to Solution.
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.
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.
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
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!
Thank you so very much! I can´t believe I did not notice that. Thanks!!