Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Accepted Solutions
Use script like this. This could perhaps be streamlined a little if some time is spent on it.
// --- First load the header line and create the field list for the LOAD From_Field
Header:
First 1
LOAD Replace([@1:n], '#|#', ',') as Fields
FROM
(fix, unicode);
Let vFields = Peek('Fields');
Let vFieldList = '';
For i = 1 To SubStringCount(vFields, ',') + 1
vField = '@' & i & ' as ' & SubField(vFields, ',', i);
vFieldList = vFieldList & If(Len(vFieldList) > 0, ',', '') & vField;
Next
// --- Load the complete lines (skip header)
Rows:
LOAD Replace([@1:n], '#|#', ',') as Lines
FROM
(fix, unicode, header is 1 lines);
// --- Parse the lines using the field list above
Data:
LOAD $(vFieldList)
From_Field(Rows, Lines) (txt, utf8, no labels, delimiter is ',', msq);
// Clean up
DROP Table Header;
DROP Table Rows;
Set vFields = ;
Set vFieldList =;
Set i =;
Use script like this. This could perhaps be streamlined a little if some time is spent on it.
// --- First load the header line and create the field list for the LOAD From_Field
Header:
First 1
LOAD Replace([@1:n], '#|#', ',') as Fields
FROM
(fix, unicode);
Let vFields = Peek('Fields');
Let vFieldList = '';
For i = 1 To SubStringCount(vFields, ',') + 1
vField = '@' & i & ' as ' & SubField(vFields, ',', i);
vFieldList = vFieldList & If(Len(vFieldList) > 0, ',', '') & vField;
Next
// --- Load the complete lines (skip header)
Rows:
LOAD Replace([@1:n], '#|#', ',') as Lines
FROM
(fix, unicode, header is 1 lines);
// --- Parse the lines using the field list above
Data:
LOAD $(vFieldList)
From_Field(Rows, Lines) (txt, utf8, no labels, delimiter is ',', msq);
// Clean up
DROP Table Header;
DROP Table Rows;
Set vFields = ;
Set vFieldList =;
Set i =;
Tresesco Actually this was posted by Ravi Kishore
i tried like below using Subfield() for few fields
Temp:
LOAD MANDT#|#PALEDGER#|#VRGAR#|#VERSI#|#PERIO#|#PAOBJNR#|#PASUBNR#|#BELNR#|#POSNR#|#HZDAT#|#USNAM#|#GJAHR#|#PERDE#|#WADAT#|#FADAT#|#BUDAT#|#ALTPERIO#|#PAPAOBJNR#|#PAPASUBNR#|#KNDNR#|#ARTNR#|#FKART#|#FRWAE#|#KURSF#|#KURSBK#|#KURSKZ#|#REC_WAERS#|#KAUFN#|#KDPOS#|#RKAUFNR#|#SKOST#|#PRZNR#|#BUKRS#|#KOKRS#|#WERKS#|#GSBER#|#VKORG#|#VTWEG#|#SPART#|#HRKFT#|#PLIKZ#|#KSTAR#|#PSPNR#|#KSTRG#|#RBELN#|#RPOSN#|#STO_BELNR#|#STO_POSNR#|#PRCTR#|#PPRCTR#|#RKESTATU#|#TIMESTMP#|#COPA_AWTYP#|#COPA_AWORG#|#COPA_BWZPT#|#COPA_AWSYS#|#KUNWE#|#LAND1#|#WW001#|#WW002#|#WW003#|#WW004#|#WW005#|#WW006#|#WW008#|#PRDHA#|#WW009#|#BZIRK#|#KTGRD#|#PSTYV#|#WW007#|#WW010#|#VKBUR#|#VKGRP#|#MATKL#|#COPA_KOSTL#|#KDGRP#|#ABSMG_ME#|#VV901_ME#|#VV902_ME#|#VV903_ME#|#VV904_ME#|#VV905_ME#|#VV907_ME#|#VV601_ME#|#VV602_ME#|#VV604_ME#|#VV605_ME#|#VV607_ME#|#VV608_ME#|#VV610_ME#|#VV611_ME#|#ABSMG#|#VV001#|#VV002#|#VV003#|#VV004#|#VV005#|#VV006#|#VV007#|#VV008#|#VV009#|#VV010#|#VV011#|#VV012#|#VV013#|#VV014#|#VV015#|#VV016#|#VV017#|#VV018#|#VV019#|#VV020#|#VV021#|#VV022#|#VV023#|#VV024#|#VV025#|#VV026#|#VV027#|#VV028#|#VV029#|#VV030#|#VV031#|#VV032#|#VV033#|#VV034#|#VV035#|#VV036#|#VV037#|#VV038#|#VV039#|#VV040#|#VV041#|#VV042#|#VV043#|#VV044#|#VV045#|#VV046#|#VV047#|#VV048#|#VV049#|#VV050#|#VV051#|#VV052#|#VV053#|#VV054#|#VV055#|#VV056#|#VV057#|#VV058#|#VV059#|#VV060#|#VV061#|#VV062#|#VV063#|#VV064#|#VV065#|#VV066#|#VV067#|#VV068#|#VV069#|#VV070#|#VV071#|#VV072#|#VV073#|#VV074#|#VV075#|#VV076#|#VV077#|#VV078#|#VV079#|#VV080#|#VV901#|#VV902#|#VV903#|#VV904#|#VV905#|#VV906#|#VV907#|#VV601#|#VV602#|#VV603#|#VV604#|#VV605#|#VV606#|#VV607#|#VV608#|#VV609#|#VV610#|#VV611#|#VV612#|#VV792#|#VV081#|#VV082#|#VV890#|#VV788#|#VV960 as fld
FROM
(txt, unicode, embedded labels, delimiter is '\t', msq);
T1:
load
SubField(fld,'#|',1) as MANDT
,SubField(fld,'#|#',2) as PALEDGER
,subfield(fld,'#|#',3) as VRGAR
,subfield(fld,'#|#',4) as VERSI
,subfield(fld,'#|#',5) as PERIO
Resident Temp;
