Field not returning dual data

[Anonymous]

Hi,

Can anyone help me to understand the return result of below script. I'm expecting the result all data in [%New_Customer_Key] field will have a dual data ('New', 1) then will rename the field into [New_VendorIndicator_].

Unfortunately, not all data in the field are tagged with the dual data. Is there something wrong here?

NewVendor:

Left Join ([Spend_Temp])

NoConcatenate

Load

     [%New_Customer_Key],

    Dual('New', 1) as [New_VendorIndicator_]

From

(qvd);

[olivierrobin]

hello

if you don't have all Customers in Merge_Data.qvd, only the customers present in this file will have New_VendorIndicator filled with dual value (as you make a left join)

the clients missing from this file will have null value

[rubenmarin · Accepted solution]

Hi Arwin, the [%New_Customer_Key] field and the values stored won't change, there will a be a new field called New_VendorIndicator_ with the dual value.