Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
arwinpabz
Contributor III
Contributor III

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.