Not able t get rid of a loop

[#1]

Hi Attached is my data view..

I am not able to get rid of the loop..

I tried to concatenate

I tried to left Join

but was not succefull.

When I concatenate the data view appears to be fine but the data is wrong..

When I do left join and reload..the script freezes while loading..

Any Idea on how can I get rid of the loop.

Thxs

[#2]

what happens when you join EngCost to QVDLoad2 ?

[#3]

Hi,

If you look at the Attached image.....there is no maching fields between the two tables beside FY and Month..

I cannot join those two fields ..

the join for the Cost Eng should be done on ManufactLbl

[#4]

1. with mappingload add Manufactlbl to QVDLoad2

2. create complex key with FY & monthname & manufactlbl to link EngCost

[#5]

Hi again,

Thxs for the quick replay..

May you please give me more details

Below is my code:

QVDLoad1:

LOAD

applymap('Manufact_Map', MANUFACTURERABBR,'Other' ) as ManufactLbl,

MANUFACTURER

//MANUFACTURERABBR

From ..\QVD\ItemMaster.qvd(qvd);

QVDLoad2:

LOAD

    MANUFACTURER,

    STN,

    ITEMPRICE,

    SALESPRICE,

    MANAGER2,

    FULL_NAME,

    MONTH,

    FY,

    ApplyMap('MonthMap',MONTH) AS MonthName

from ..\QVD\ShipItem.qvd(qvd);

QVDLoad3:

LOAD STN,

     COST

From ..\QVD\Putbom.qvd(qvd);

EngCost:

LOAD A as ManufactLbl,

     B as FY,

     C as MonthName,

     D as EngCost

FROM

C:\QlikViewReports\Sourcedocuments\DataFiles\CostEng1.xlsx

(ooxml, no labels, table is Sheet1);

Thxs