fill transformation for multiple files

[louisernould]

hi everybody,

i'm a newbee in Qlikview and I have a problem with the fill transformation.

here it is:

I want to analyse a just some lines in multiples excel files:  I have 50 files with quite the same name (test1.xls, test2.xls,...test50.xls and it is the same architecture in the files) and I want only the 3 first lines. So, I used "where RowNo()<3" at the end. No problem for this.

My problem appears because I have in my fist column one date (date1) for other dates (Date2) and when do the "fill transformation", the final table makes the fill transformation only for the first file and not for the other.

To resume: I have two steps I have to do:

- make a big table with the 3 first lines of multiples excels files

- fill the empty fields with the upper date

for example:

test1.xls

Date1	Date2	quantity
01/01/2014	01/01/2014	10
	02/01/2014	10
	03/01/2014	20

test2.xls

Date1	Date2	quantity
02/01/2014	02/01/2014	10
	03/01/2014	20
	04/01/2014	20

test3.xls

Date1	Date2	quantity
03/01/2014	03/01/2014	20
	04/01/2014	20
	05/01/2014	30

The final Table that qlikview gives me:

Date1	Date2	quantity
01/01/2014	01/01/2014	10
01/01/2014	02/01/2014	20
01/01/2014	03/01/2014	20
02/01/2014	02/02/2014	10
03/01/2014	03/01/2014	20

And what I really want:

Date1	Date2	quantity
01/01/2014	01/01/2014	10
01/01/2014	02/01/2014	20
01/01/2014	03/01/2014	20
02/01/2014	02/02/2014	20
02/01/2014	03/01/2014	20
02/01/2014	04/01/2014	30
03/01/2014	02/01/2014	30
03/01/2014	03/01/2014	30
03/01/2014	04/01/2014	40

My code is:

LOAD

     Date1,

     Date2,

     quantity

FROM

(biff, embedded labels, filters( Replace(1, top, StrCnd(null))))

where RowNo()<3;

I really hope it's enough clear, if it's not, don't hesitate, tell me and i will try to be more

I tried a lot of thing but now I don't have more ideas...

Thanks a lot

Louis

[louisernould]

Hi again

Thank everybody for all your answers !!

I got it !!  The problem was about RowNo() and RecNo()... and from Manish with his solution

The answer was here: rowno() and recno()

Have a nice day , and thanks again for the differents solutions you gave to me

Louis