Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Correct_Answer
Contributor II
Contributor II

Need to combine two field values to one field with condition.

Hello Team,

Can any one help me on this, I have 2 fields present in my dataset, Please find the below example,

Correct_Answer_0-1622570774423.png

and I want to make it as one field like if (Order ID1 is not blank then orderID1 else orderID2.

 

expecting output like below.

Correct_Answer_1-1622571142845.png

 

 

Thanks in Advance

 

Labels (1)
  • Other

1 Reply
rwunderlich

Best to do this in the load script. 

if(len(orderID1) > 0, orderID1, orderID2) as SalesOrderId

If the fields are in different tables and you have questions about how to go about it, please post an image of your data model.

-Rob