'Replace Only' not working correctly !!

[nikhilgarg]

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

[Anonymous]

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

[Gysbert_Wassenaar]

Can you post a document that demonstrates the problem?

[nikhilgarg]

HEy,

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

Check out the help.

Thanks

[nikhilgarg]

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.