topic Re: Field not returning dual data in QlikView

Field not returning dual data

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Field not returning dual data

olivierrobin — Wed, 25 Apr 2018 13:38:24 GMT

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

Re: Field not returning dual data

rubenmarin — Wed, 25 Apr 2018 13:50:04 GMT

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.