Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello ,
Below is 2 tables -
table 1 -
Table 2 -
Doing left outer join on table 1 with table 2 on file # and brining out release # from table 2. When am expanding am getting this output which is wrong-- the records are getting duplicated with release #'s with 14 records. Actual out put should be in 3rd screen shot should be 7 records the release # are duplicating . Please advice.
Hello Thankyou for your reply, Join should be on both File # and TG/Amount then the outcome is coming as expected.
Yes if Join on only File# behaviour is right output is wrong.
Why should the first line in your first table be release 273545 and not 273526? What identifies it as belonging with 273545? The behaviour you are seeing is exactly how a left outer join on File# only should work.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |