Question

To keep from overwriting existing fields with your Lookup you can use the ____________ clause.

Answer 1

Hi Friend

Here is your answer :

__________________________

To keep from overwriting existing fields with your Lookup you can use the outputnew clause.

__________________________

Hope it helps :)

Answer 2

The answer to your question is outputnew clause.

When the outputnew clause is used, the lookup operation is not performed for the events in which the output field already exists preventing overwriting existing fields. Thus, to keep from overwriting existing fields with your Lookup you can use the outputnew clause.