Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need some assistance please. Loading the following, I get a Table1 with each line duplicated 3 times because the DOCNO appears 3 time in table2. Any idea how I can eliminate the duplicates?
Thank you.
Table1:
LOAD DOCNO,
COST_AMOUNT,
ENTRY,
GLNO,
MONTH,
PERIOD,
PROJNO,
REF,
SALE_AMOUNT,
TRANS_DATE,
YEAR
FROM
(ooxml, embedded labels, table is GL);
Left Join Table1:
Table2:
LOAD DOCNO,
ACCNO,
REP,
STOCKNO
FROM
(ooxml, embedded labels, table is Stock);
May be do applymap instead of join here
Hi,
If DOCNO appears 3 time in table2 with same combination for other fields, you must simply add a DISTINCT
Left Join Table1:
Table2:
LOAD DISTINCT DOCNO,
ACCNO,
REP,
STOCKNO
FROM
(ooxml, embedded labels, table is Stock);
Thank you.
Below is my resultant table. You see the DOCNO is the same but it duplicates for each STOCKNO.
Which of the three STOCKNO would you like to see in your resultant table?
Thank you for your assistance.
I would like to see:
SERV_INTERFORM with REVENUE = 113 232
100200 with REVENUE = 9 020
110200 with REVENUE = 20 335
SERVE INTERFORM with COST OF SALE = 65 275
100200 with COST OF SALE = 11 742
But I guess how did you decide this? I mean we need to understand the logic so that we can provide a solution which might work in all cases. You probably need to provide a sample app or sample data to help us help you
Hi, I would send you the qvw and the excel if I I could work out how to upload it.
Just what you need
Please refer to the attached.