QV as an ETL tool

[Anonymous]

I am extracting data from a source and would want to do the following action before loading the data into QV:

1. If a field [Doctor Number] is Null an entry of '00000' should be entered into this field value and;
2. If a field [Med Aid] is Null an entry of 'UNKNOWN' should be entered into this field's value.

How can this be accomplished in QV before/during the loading process?

Regards.

[sunny_talwar]

There is small difference. If you have white spaces, IsNull won't be able to catch them, but Len(Trim()) will. So I find it more useful to use Len(Trim()) instead of IsNull just because I believe white spaces are nulls. If you don't want to take them as nulls, then IsNull() is your function

[Anonymous]

Thanks once again

[Anonymous]

Thanks Sunny for the swift and very elegant explanation