Partial LOAD

[#1]

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.

[tresesco]

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

[#3]

HI, tresesco.

that I want solution is complex?

file is just about 300kb.

[tresesco]

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.

[#5]

ok, now I'm using whole contents.

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

Thank you Tresesco.

[its_anandrjs]

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

[#7]

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.