Hi All
Can some one share with me , why must add concatenate , so that it will load the data faster , and not get memory over flow error msg ?
For Each i in 'PM','LE','DA','PW','SD'
INVC_TABLE:
LOAD
'$(i)' as SOURCE,
[Stock Code] as [PRODUCT_CODE_INV],
[Stock Description] as [DESC_INVENTORY_TABLE],
Warehouse,
[OnHand Qty] as QTY_O,
[OnHand Qty]*[Unit Cost] as C_ONHAND_AMT,
[Produc Class] ,
ApplyMap('Map_INVC_PMC',[Manufacturer (Brand)],'OTHERS') as [BRAND_INV],
[Manufacturer (Brand)]as [BRAND_INV_SUB]
FROM
$(vRAWPath)INVC_$(i).CSV
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
NEXT i;
For Each i in 'TS'
INVC_TDS:
concatenate
LOAD left(FileBaseName(), 4) AS Report_dod_1,
'$(i)' as SOURCE,
@297:354T as [PART_NO_],
@295:354T as [PART_NO_N],
@1:11T as [PRODUCT_CODE_INV],
@286:296T as [invc_date],
@320:354T as [M_DATE_],
Date(Monthstart(@320:354T), 'DD-MMM-YYYY') as M_DATE,
Date((@286:296T), 'DD-MMM-YYYY') as INVC_DATA_TDSS
FROM $(vRAWPath)INVC_$(i).TXT (ansi, fix, no labels, header is 0, record is line);
NEXT i;
Paul
