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

[Correct_Answer]

Hello Team,

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

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

expecting output like below.

Thanks in Advance

[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

[Nolgath]

Thank you so much, you solved my problem in such a simple way, thank you Rob.

Wish you all the best, cheers.