Qlik Community

App Development

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

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Correct_Answer
Contributor III
Contributor III

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