Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Field not returning dual data

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);

1 Solution

Accepted Solutions
rubenmarin

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.

View solution in original post

2 Replies
olivierrobin
Specialist III
Specialist III

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

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.