Left Join not working properly with multiple files load using "*"

[rohitk1609]

Hi Techies,

I have a use case where I have two kinds of files.

1. Sales_2017, Sales_2018 and Sales_2019

2. Labour_2017,Labour_2018 and Labour_2019

Then I write the load script as:

Sales:

Load

*

from lib://$(Path)/Sales_20*.qvd]

left join

Sales:

Load

*

from lib://$(Path)/ Labour_20*.qvd]

The output is having data for 2017 Labour table only and skip  Labour_2018 and  Labour_2019.

If I remove  the left join then linking works fine for all three years fine but Left Join maps data for the first file of second table set.

My question is , is it a bug in Feb 2019 version ?

Thanks,

Rohit

[jonathandienst]

Marcus already explained why this occurs and it is not a bug.