Incremental load issue

[#1]

HI guys,

I have a script for incremental load.

NoConcatenate

        NameIncremental:

        LOAD

        $(AllColumnNames);

        SQL Select $(AllColumnNames) FROM $(vResTable)

        where $(vWhereClause);

Concatenate (NameIncremental)

            LOAD

            $(AllColumnNames)

            Resident Name

            where not Exists ($(vPrimaryKey));

The problem with is....

the last load statement loads only what is in NameIncremental and do not concatenate with Name resident.

What am i doing wrong here?

Regards,

Saurabh