topic combining data files in QlikView

combining data files

qlikhans — Thu, 01 Sep 2011 19:21:13 GMT

Every month I load receive 4 files with the same structure:

LOAD Bookyear,

Ledger,

Bookdate,

Debit,

Credit

FROM

[Ledger 201101.csv]

(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

I append to the load: MONTH(Bookdate) as Bookmonth,

1. How can I avoid that every month the line MONTH(Bookdate) as Bookmonth must be added. Is it possible to arrange that in 1 line which is valid for the whole QV-file

2. suggestions for a smart method of adding a new month to the previous ones?

combining data files

ToniKautto — Thu, 01 Sep 2011 20:16:14 GMT

Not sure I understood what you are doing currently and in what way that is not working for you. Could you please provide a sample QVW of your script, and some additional details on the problem you observe.

combining data files

erichshiino — Thu, 01 Sep 2011 21:36:19 GMT

I'm not sure if I understood either.

Maybe you just need a script like this:

LOAD Bookyear,

Ledger,

Bookdate,

month(Bookdate) as Bookmonth,

Debit,

Credit

FROM

[Ledger 201*.csv]

(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

With the *, you can read all the files with similar names in the folder and create a field for all of them.

Hope this helps,

Erich

combining data files

qlikhans — Fri, 02 Sep 2011 15:54:42 GMT

Hi Tony,

I think the suggestion Erich did combines my two questions into one solution. I will be testing that first.

thank you for your reaction

Kind regards

Hans

combining data files

qlikhans — Fri, 02 Sep 2011 15:56:00 GMT

Hi Tony

I will test your suggestion. It makes sense.

Will come back to you.

Kind regards

Hans