case 837 In what situation need to use concatenate ?

[paulyeo11]

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

[Saravanan_Desingh · Accepted solution]

If any two Tables which has the same Field Names, it will be auto Concatenated. If the Table Fields are not exactly same and still want to Concatenate the data, we have to use Concatenate.