Difference between ADD and Concatenate?

[nihhalmca]

Hi All,

Could you people say exact difference b/w ADD and Concatenate

Thanks in Advance,

Nihhal.

[#2 · Accepted solution]

Concatenate

If two tables that are to be concatenated have different sets of fields, concatenation of two tables can still be forced with the concatenate prefix

ADD

The add prefix can be added to any load, select or map...using statement in the script. It is only meaningful during partial reloads. During a partial reload the QlikView table, for which a table name is generated by the add load/add select statement (provided such a table exists), will be appended with the result of the add load/add select statement.

[nihhalmca]

Thanks for response.