Adding data

[#1]

Hi All,

I want to add two excel data. One with many fields and other with few fields. I have used alias so that it adds to the same field.

Please let me know is there any mistake.

OutFlowData:

LOAD Co.code,

     V.Code,

     V.Name,

     [Doc. Type],

     [Payment Doc No],

     [Line Item No],

     [Payment Date],

     [Spl G/LAcc],

     [Paid amt],

     [TDS Amt],

     [Paid Amt+TDS],

     [Line Item Amt],

     [Inv Doc No],

     Year,

     [Bill No],

     [Inv Date],

     [Source Doc.Type],

     [Inv Posting Date],

     [Inv Amt],

     Curr.,

     [PO No],

     [PO Item No],

     [PO Date],

     [PO Value],

     [Service Activity],

     [Activity Short Text],

     Mat.Code,

     Mat.Desc,

     [WBS Element],

     Assignment,

     [Network Activity],

     [Internal Order],

     [Project Code],

     [Project Name],

     [Payment Method],

     [Payment Ref.No],

     [Cheque Date],

     H.Text,

     [G/L Acc.],

     [G/L Desc.],

     [Payee Bank],

     [Name of Bank],

     Cl.Doc.No,

     Cl.Date

FROM

[..\10_data_sources\Excel\cashflow-*.csv]

(txt, codepage is 1252, embedded labels, delimiter is '\t', no quotes, no

eof) Where  [Doc. Type]<>'PC' and [Doc. Type]<>'FR' and [Doc. Type]<>'FP';

Concatenate(OutFlowData)

LOAD CoCd as Co.code,

     DocumentNo as [Payment Doc No],

     [Pstng Date] as  [Payment Date],

     Type as [Doc. Type],

     Assignment,

     [Document Header Text] as H.Text,

     [WBS element],

     //[Doc. Date],

     [Amount in local cur.] as [Paid amt],

     //LCurr,

     //Text,

     Vendor as V.Name

FROM

(biff, embedded labels, table is LOANCASHFLOW$);

Regards,

Keerthi KS

[puttemans · Accepted solution]

Hello,

This seems to be ok. Beware that there is a lot of variables you do not fill with the concatenate. Therefore, you may rethink the structure of you data/the content of your OutFlowData when files start to become too big.

Regards,

Johan

[#3]

I need to add data only for those fields. If i load above script  both the table data will be concatenated right. whichever the  variables i have used

[puttemans]

Yes, both tables will be put together, as your data fields are similar, and you force the merge with the concatenate statement.

Regards,

Johan

[jagan]

Hi Keerthi,

You can concatenate both the tables, since all the columns in table 2 are there in table1.  The columns which are not in Table2 will get Null values.  Please take care this.  If there is any other source to get the missing columns in Table2 then you can bring those fields and concatenate both the tables.

Regards,

Jagan.