Empty results from join tool

[RogerioReisBR]

Hi There!

I'm having some trouble with the join tool.....again.....but this time, I think I've covered my bases and really can't tell what is wrong.

On the left, I have some data (already filtered Pedido (Order) only 201886027). And both columns Pedido and Item2 are Int64 ( I know it's not optimized - will fix it later - it is just an attempt to make sure the datatypes are not an issue. I have tried other data types, also with no sucess)

And on the right

I have the columns VBELN and KPOSN which are equivalent to Pedido and Item2 respectively). Also Int64.


When I run the Flow, I get 0 results from all the JOIN exits. L,J and R are empty.

Interesting enough, If I save the input from both L and R on separate files and open a new flow, joining them just like the original, it works.....without changing a single thing in the join.

What am I doing wrong?

Thank you a million!

[apathetichell]

I am confused - your browse tool isn't connected to this join tool. It's connected way down your workflow somewhere. Your other join tool has a big red mark - to say it isn't configured. That's why you have nothing in browse. Connect your browse form this join tool and see the results...

[RogerioReisBR]

Thank you for your response. 

The big red mark was something I added to the screenshot to enphasize the join I was mentioning ( and all the other red marks)

I am checking my results (or lack of) in the results panel.

When I add a browse tool at the J exit of the join (or R or L) I get 0 results,

Thank you for your time and help

[apathetichell]

can you add browse to left & right too? also is there dynamic data (ie an app?) if so it could change column types based upon actual data fed in.

My hypothesis would still be that you have another error somewhere and your workflow doesn't make it to the join tool... or something like that.

[RogerioReisBR]

Sure can.

Browse from Left

Browse from Right

Now please notice that I added two outputs (base1 and base2) from the same input as the joins.

When I create a new flow joining these two results, look at the results: 

Information on the Join ( to prove they are the same fields)

Browse results from L

Browse results from J

Browser results from R

[apathetichell]

o.k. - part of my hypothesis has been proven - that the join tool isn't producing data - not that the join anchor isn't working. Delete that join. Put on a new join. re-run workflow. Post message results?

[RogerioReisBR]

Hi! I deleted the join. Recreated it. Same results.

I started a new flow recreating the same conditions and it is working now. I still have no idea what happened, but start a new flow was a faster solution. 

Thank you for your assistance.