topic Re: Partial LOAD in QlikView

Partial LOAD

Mon, 31 Mar 2014 04:34:36 GMT

Hi, ALL.

now I met a problem about Partial LOAD.

when I try to load a Excel File, I wanna partial content through some Condition.

(because I will setting monthly on management console)

ex.

already loaded a file is

Target_w:

LOAD month

, no

, id

, number

FROM

[test.xlsx]

(ooxml, embedded labels, table is Sheet1);

STORE Target_w into noq.qvd;

drop table Target_w

then After few weeks,

excel file will become this with adding 3 rows.

so, when automatically Reload works, just adding 3 rows in a same qvd file.

(previously loaded file's content are not changed, just adding)

I try to compare 'no'column as 'where condition', but not working.

how I Edit Script?

thanks any comments.

Re: Partial LOAD

tresB — Mon, 31 Mar 2014 04:50:03 GMT

Is your table too big? Otherwise I guess simply reloading the file and overwriting the qvd works.

Re: Partial LOAD

Mon, 31 Mar 2014 04:57:46 GMT

HI, tresesco.

that I want solution is complex?

file is just about 300kb.

Re: Partial LOAD

tresB — Mon, 31 Mar 2014 05:19:48 GMT

No, solution is not very complex. You can do it comparing 'no' field (as you thought of). It would be sort of incremental load rather than partial load, however if you really want the partial one you can try with 'Replace' keyword. What I meant is if the file size is that small, I would recommend(unless you want that for learning purpose) the direct load and rewrite qvd, that would be simpler.

Re: Partial LOAD

Mon, 31 Mar 2014 05:33:33 GMT

ok, now I'm using whole contents.

It will become a huge, at that time I should use replace.

Thank you Tresesco.

Re: Partial LOAD

its_anandrjs — Mon, 31 Mar 2014 05:47:31 GMT

I think Incremental load works here you already using no field so you have to use exist or max key to identify new records in the table and then add the rows in the table by incremental load.

Hope this helps

Thanks & Regards

Re: Partial LOAD

Mon, 31 Mar 2014 05:58:40 GMT

oh....I used 'Replace' as test and some of learning purpose.

what is the differences with replace use and not.

I dont know that.

Replace also reload all contents with adding edited content as one excel file...

thank you.