topic Re: data Load in QlikView

data Load

Fri, 22 Jun 2012 19:11:56 GMT

i want to load data attached in file but i want to add only 6 th and 14 th row in qvd.

but there is no fix rule that the row i want to add in qvd will be at 6th and 14 th row next time.

may be next month row no will be else other.

so i need a fix rule so that qlikview read only requird row every time.

Re: data Load

Jason_Michaelides — Fri, 22 Jun 2012 19:46:35 GMT

What logic determines which rows should be added to the QVD file?

Re: data Load

Fri, 22 Jun 2012 20:37:08 GMT

Actually

when i fatech data from source it comes out like

attached in sheet after some row there is a row which have 1column name null.

but value is use full .

i was tring with null column but there is no certain rule after how many rows ,i will

get that row which i column is null.

Re: data Load

Jason_Michaelides — Fri, 22 Jun 2012 20:53:12 GMT

I'm not sure I understand you. Are you saying some rows will have a null value for a particular column and these are the ones you want? You said you want rows 6 and 14 from the attached file but I can't see what makes these rows any different from the others.