Issue with left keep

[#1]

Hi, I have two tabs tab1 and tab3. Tab 3 is left kept with tab1. Tab1 has a number of rows, but tab3 only has 2 rows. So I expect tab3 after left keep to have only 2 rows but it seems to contain 3 rows. I have attached my qvw. Please help.

From this qvw, it looks like left join and left keep behave the same way. Please have a look.

Thanks

Ram

[hic · Accepted solution]

No, tab3 has only two records. Just as you expect. But the key "country" of course has more values.

HIC

[#3]

Thanks Henric. Got the crux of it now.

[#4]

Thanks Henric. Got the crux of it now.