topic Re: Adding data in QlikView

Adding data

Mon, 24 Aug 2015 08:43:43 GMT

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

Re: Adding data

puttemans — Mon, 24 Aug 2015 08:52:38 GMT

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

Re: Adding data

Mon, 24 Aug 2015 09:00:03 GMT

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

Re: Adding data

puttemans — Mon, 24 Aug 2015 09:04:51 GMT

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

Regards,

Johan

Re: Adding data

jagan — Mon, 24 Aug 2015 10:06:24 GMT

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.