duplicate values by using of left join

[beck_bakytbek]

Hi Folks,

i have two table:

Category	Product	Sales
C1	p1	10
C1	p1	50
C2	p2	20
C2	p3	12
C2	p3	41
C3	p2	15

Category	Product	Cost
C1	p1	5
C1	p1	10
C2	p2	20
C2	p3	10
C2	p3	12
C3	p2	4

if i use the left join, than i have a duplicate values, i can solve it by using of concatenation, does anybody have any idea how to solve it by another way?

Thanks a lot

Beck

[beck_bakytbek]

can you please give me an example

[PrashantSangle · Accepted solution]

Try Below script

Test:

LOAD Distinct

Category,

    Product,

    Sales

FROM

Book1.xlsx

(ooxml, embedded labels, table is Sheet2);

Left Join

LOAD Category,

    Product,

    Cost

FROM

Book1.xlsx

(ooxml, embedded labels, table is Sheet3);

Exit SCRIPT;

Also sample data attached.

[beck_bakytbek]

Hi Sangle thanks a lot for your help and time