Join block

[elfunambolo]

Hello,

I want to insert value (TGT TOT) based on field key (IBAS Event). I have two files, the right one contains the values to be insert in the left file. I used Join block but I didn't obtain the expect result.

Could you support me?

Thanks

[afv2688]

Hello @elfunambolo ,

Based on your workflow it seems you are trying to get to match not only the IBAS ID but also the TGT TOT amounts on both tables. That means, even if the amounts are slightly different they won't join. Would recommend you only to perform the join based on the IBAS ID and see the results.

Cannot do more since you didn't share the files

Hope that helps

Regards

[elfunambolo]

Ok, but the Join output contains only rows with IBAS ID present in the right file. I need to insert these TGT TOT values in the left file (in the column TGT TOT [€]).

Thanks

Giovanni

[afv2688 · Accepted solution]

Hello @elfunambolo ,

I think I understood what you need.

How about now?

Regards