Look up - Condition Not met - Options

[sreelalpp]

Hi

Setting 'Continue' option for 'Condition Not met' clause is equivalent to setting no conditions. Correct ?

Or is there any use of this combination ?

thanks,
Sree

[rajeevm]

Hi

If the lookup does not match then giving the condition as 'Continue' you wont' miss any rows. Atleast on the target side you can have those rows which do not have lookup condition matched

Thanks
rajeev

[ray.wurlod]

Setting 'Continue' option for 'Condition Not met' clause is equivalent to setting no conditions. Correct ?

No.
The default is Fail.

[sreelalpp]

Thanks for your reply Ray & Rajeev

Ray,

Yes. default is 'Fail'. But without giving any condition is there a meaning for this default value ?

Also is it not same as giving a condition and setting the 'Condition Not met' option to 'Continue' ?

Thanks,
Sreelal

[ray.wurlod]

You can't not give a condition.

[raghu22]

As far my understanding, lookup will check the source data with lookup data and returns value to target... when you give a condition in the lookup, it will only check the source data which statisfies that condition and returns the lookup value and which doesnt satisfy that condition, it directly pass the source value to the target... if dont provide the condition, it checks all the source data with lookup data... This is the difference... So condion not met=Continue is not the same as without any condition....

Correct me if i'm wrong...

[ray.wurlod]

You're wrong.

There's always a condition.

The default is Fail.