Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
can you please give me an example
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.
Hi Sangle thanks a lot for your help and time