topic Re: 'Replace Only' not working correctly !! in QlikView

'Replace Only' not working correctly !!

nikhilgarg — Thu, 25 Sep 2014 10:05:18 GMT

Hey,

If i am not wrong , in Replace command the new table is created replacing old data.

I am using 'Replace Only' , but my old table1(with first load) is not deleted and new Table1(with second load) is not created on partial load. Rather both of them remains on partial load. Code is :

------------------------------------------------------------

Directory;

Table1:

LOAD Id,

Name

FROM

Book4.xlsx

(ooxml, embedded labels, table is Sheet1);

Table1:

Replace Only LOAD Id

FROM

Book4.xlsx

(ooxml, embedded labels, table is Sheet1);

Please tell what to do.

Thanks

Re: 'Replace Only' not working correctly !!

Anonymous — Thu, 25 Sep 2014 10:27:07 GMT

Hi Nikhil,

Write it as :

Table1:

Replace LOAD Id

FROM

Book4.xlsx

(ooxml, embedded labels, table is Sheet1);

it will append the ID column with new ID's.

Thanks

Manish Madan

Re: 'Replace Only' not working correctly !!

Gysbert_Wassenaar — Thu, 25 Sep 2014 10:29:45 GMT

Can you post a document that demonstrates the problem?

Re: 'Replace Only' not working correctly !!

nikhilgarg — Thu, 25 Sep 2014 10:38:19 GMT

HEy,

But Replace doesnot appends anything. It only replaces old data with new data.

Check out the help.

Thanks

Re: 'Replace Only' not working correctly !!

nikhilgarg — Thu, 25 Sep 2014 10:39:40 GMT

Hey ,

I got the problem . Actually i was using two different number of fields in both load . So two different tables created. But with same no. of columns in each load it does as specified in help.

Thanks.