Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm loading dimensions from various tables, however there are duplicate values because of a field in one of the tables. how to keep a straight table free of duplicate.
Although SoldQRcode and Sold I'd are unrelated, SoldQRcode is making duplicates
After loading data in QS Straight Table | ||||
Barcode(Keyfield) | Name | Country | Sold QR Code | Sold Id |
1 | Gold | Canada | A1 | 100 |
1 | Gold | Canada | A2 | 101 |
1 | Gold | Canada | A3 | 102 |
1 | Gold | Canada | A1 | 103 |
1 | Gold | Canada | A2 | 104 |
1 | Gold | Canada | A3 | 105 |
2 | Diamond | Dubai | B1 | 201 |
2 | Diamond | Dubai | B1 | 202 |
3 | Silver | Aus | C1 | 301 |
3 | Silver | Aus | C2 | 302 |
3 | Silver | Aus | C1 | 303 |
3 | Silver | Aus | C2 | 304 |
4 | platinum | Uk | D1 | 401 |
4 | platinum | Uk | D1 | 402 |
Excepting output in below format
Table | ||||
Barcode(Keyfield) | Name | Country | Sold QR Code | Sold Id |
1 | Gold | Canada | A1 | 100 |
1 | Gold | Canada | A2 | 101 |
1 | Gold | Canada | A3 | 102 |
1 | Gold | Canada | 103 | |
1 | Gold | Canada | 104 | |
1 | Gold | Canada | 105 | |
2 | Diamond | Dubai | B1 | 201 |
2 | Diamond | Dubai | 202 | |
3 | Silver | Aus | C1 | 301 |
3 | Silver | Aus | C2 | 302 |
3 | Silver | Aus | 303 | |
3 | Silver | Aus | 304 | |
4 | platinum | Uk | D1 | 401 |
4 | platinum | Uk | 402 |
Hi,
your keyfield is A_Barcode, so with left join 1 you'll get all Sold QR Code" linked by this field and with the second left join you'll get all Sold id linked by A_Barcode. For your expected result Table C also needs a field Sold QR Code.
In you example, 1 as C_Barcode and Sold id 100 needs A1 as Sold QR Code.
Regards
In you example, 1 as C_Barcode and Sold id 100 needs A1 as Sold QR?? Need to create new columns in temp table ??