Hello to everyone,
i have a little problem. I'm not quit sure how to solve it. I have to create a table with production ordres since 2018 up to today.
Because it is just possible for us to write querys / reporst in ERP System which contanis not more than 215 charaters (not colums!!!) I have to write three different reports to get all the informations. So far so good.
All reports contains the same number of rows, in ervery report I wrote the same three fields in front of the report, which im using for connecting the tables in power query. This are the fields production order number, postion on the workorder and the number of the workplace as you can see in the following srceenshots. For every of the three reports the rows for the prodution order 100005 are twelve rows as result.
When I'm going to combine these three reporst by using these three fields as connector i would like to have twelve lines in total for the joined table of all colums.
I tried first left outer join and second inner join as joins. The problem is that I get about 84 rows for the joinded table. It's seems a little bit like using a crossjoin for the tables.
Could you help me to find a solution for this joining problem? Do I have to use an other join type, or is it just not possible what I expected and would like to have as a result?
Because in total every report contains 144.008 rows and these leads to more than 1'048'576 rows for the joined tables.
Thanks in advance.