https://community.qlik.com/t5/App-Development/Need-to-combine-two-field-values-to-one-field-with-condition/m-p/1812227#M66270 <P>Best to do this in the load script.&nbsp;</P><P>if(len(<SPAN>orderID1) &gt; 0,&nbsp;orderID1, orderID2) as SalesOrderId</SPAN></P><P><SPAN>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.</SPAN></P><P><SPAN>-Rob</SPAN></P> Tue, 01 Jun 2021 19:47:17 GMT rwunderlich 2021-06-01T19:47:17Z https://community.qlik.com/t5/App-Development/Need-to-combine-two-field-values-to-one-field-with-condition/m-p/1812202#M66264 <P>Hello Team,</P><P>Can any one help me on this, I have 2 fields present in my dataset, Please find the below example,</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Correct_Answer_0-1622570774423.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/56091i38B69873B59743CD/image-size/medium?v=v2&amp;px=400" role="button" title="Correct_Answer_0-1622570774423.png" alt="Correct_Answer_0-1622570774423.png" /></span></P><P>and I want to make it as one field like if (Order ID1 is not blank then orderID1 else orderID2.</P><P>&nbsp;</P><P>expecting output like below.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Correct_Answer_1-1622571142845.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/56092i3BF73BF6F7EA1727/image-size/medium?v=v2&amp;px=400" role="button" title="Correct_Answer_1-1622571142845.png" alt="Correct_Answer_1-1622571142845.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P><P>Thanks in Advance</P><P>&nbsp;</P> Tue, 30 Nov 2021 18:17:33 GMT https://community.qlik.com/t5/App-Development/Need-to-combine-two-field-values-to-one-field-with-condition/m-p/1812202#M66264 Correct_Answer 2021-11-30T18:17:33Z https://community.qlik.com/t5/App-Development/Need-to-combine-two-field-values-to-one-field-with-condition/m-p/1812227#M66270 <P>Best to do this in the load script.&nbsp;</P><P>if(len(<SPAN>orderID1) &gt; 0,&nbsp;orderID1, orderID2) as SalesOrderId</SPAN></P><P><SPAN>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.</SPAN></P><P><SPAN>-Rob</SPAN></P> Tue, 01 Jun 2021 19:47:17 GMT https://community.qlik.com/t5/App-Development/Need-to-combine-two-field-values-to-one-field-with-condition/m-p/1812227#M66270 rwunderlich 2021-06-01T19:47:17Z https://community.qlik.com/t5/App-Development/Need-to-combine-two-field-values-to-one-field-with-condition/m-p/2032450#M85069 <P>Thank you so much, you solved my problem in such a simple way, thank you Rob.</P> <P>Wish you all the best, cheers.</P> <P>&nbsp;</P> Tue, 31 Jan 2023 20:21:06 GMT https://community.qlik.com/t5/App-Development/Need-to-combine-two-field-values-to-one-field-with-condition/m-p/2032450#M85069 Nolgath 2023-01-31T20:21:06Z