Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Diff:Between(ADD & REPLACE)

Hello Fiend Good Day To All...

i want to know Diff..between ADD & Replace..

when am using ADD & REPLACE ,am getting same result so if any body explain...

Ex:

Table1:

col1,col2

a    ,  b

c    ,  d

Table2:

ADD Or Replace

col3,col4

1   ,   2

3   ,   4

am getting the same result when partial load...TIME(Ex:10 sec)

4 Replies
jvitantonio
Specialist III
Specialist III

Hola, esto es un grupo en español por lo tanto la respuestas sera en español.

If you don't speak Spanish, please move the thread to outside this group.

Replace = reemplaza tu tabla completamente. Es decir, la elimina y la recrea con los datos que estes cargando. Tiene el mismo efecto con una "full reload" o "partial reload".

Add =  se usa solamente con "partial reload". En este caso, la tabla no se elimina, sino que los datos que estes cargando, se agregaran a los ya existentes. Si hace un full reload, esta parte del script no se ejectara.

El resultado no es el mismo.

Prueba esto:

replace B:

LOAD * INLINE [

    F1, F2

    1, 2

    3, 4

];

Add A:

LOAD * INLINE [

    F1, F2

    a, g

    b, x

];

Saludos

JV

Not applicable
Author

Thank you...can u please in ENGLISH

cfz
Former Employee
Former Employee

Hi Sk Rafi,

This is  a group that uses Spanish, you should do as QL suggest and move the thread to one of the English groups in order to get more and quicker answers.

In short, I can say that replace substitute a table for another while add append the result of a load to an existing table. Both are mostly useful when doing Partial Reload (Ctrl+Shift+R). You can see examples of the use of both functions in the dekstop help and in the Reference Manual.

Regards

Carlos.

Not applicable
Author

Thank you