topic Re: Merging Single Filed values into One in App Development https://community.qlik.com/t5/App-Development/Merging-Single-Filed-values-into-One/m-p/2028565#M84750 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/154754">@zar</a><FONT color="#009845"><U>zar </U></FONT></P> <P>ThankYou for providing the solution.&nbsp;</P> Sun, 22 Jan 2023 12:17:58 GMT jyoshna 2023-01-22T12:17:58Z Merging Single Filed values into One https://community.qlik.com/t5/App-Development/Merging-Single-Filed-values-into-One/m-p/2028555#M84745 <P>HI Team,</P> <P>I have a field called Commodity Group which has data as below, I want Natural Gas and Nat Gas ICE to be represented as Natural Gas under Commodity_Type. How to achieve this.</P> <TABLE width="113"> <TBODY> <TR> <TD width="113">Commodity_ Type</TD> </TR> <TR> <TD><STRONG>Natural Gas</STRONG></TD> </TR> <TR> <TD>Agriculture</TD> </TR> <TR> <TD>Base Metals</TD> </TR> <TR> <TD>Crude oil</TD> </TR> <TR> <TD>Refined Product&nbsp;</TD> </TR> <TR> <TD><STRONG>Nat Gas ICE</STRONG></TD> </TR> <TR> <TD>Pre Metal</TD> </TR> </TBODY> </TABLE> Sun, 22 Jan 2023 10:13:11 GMT https://community.qlik.com/t5/App-Development/Merging-Single-Filed-values-into-One/m-p/2028555#M84745 jyoshna 2023-01-22T10:13:11Z Re: Merging Single Filed values into One https://community.qlik.com/t5/App-Development/Merging-Single-Filed-values-into-One/m-p/2028564#M84749 <P>Hi!</P> <P>Yo can use Mapping to achieve the change (if you are using load script):</P> <DIV><EM>Map_Correction_Gas:</EM></DIV> <DIV><EM>Mapping</EM></DIV> <DIV><EM>Load * Inline [</EM></DIV> <DIV><EM>MapFrom, MapTo</EM></DIV> <DIV><EM>Nat Gas ICE, Natural Gas</EM></DIV> <DIV><EM>]</EM></DIV> <DIV><EM>;</EM></DIV> <DIV>&nbsp;</DIV> <DIV>&nbsp;</DIV> <DIV><EM>DATA:</EM></DIV> <DIV><EM>Load&nbsp;</EM></DIV> <DIV><EM>[Commodity_Type]</EM></DIV> <DIV><EM>&nbsp; &nbsp; ,ApplyMap('Map_Correction_Gas',[Commodity_Type],[Commodity_Type]) as [Corrected_Commodity_Type]</EM></DIV> <DIV><EM>;</EM></DIV> <DIV><EM>Load * Inline [</EM></DIV> <DIV><EM>Commodity_Type</EM></DIV> <DIV><EM>Natural Gas</EM></DIV> <DIV><EM>Agriculture</EM></DIV> <DIV><EM>Base Metals</EM></DIV> <DIV><EM>Crude oil</EM></DIV> <DIV><EM>Refined Product&nbsp;</EM></DIV> <DIV><EM>Nat Gas ICE</EM></DIV> <DIV><EM>Pre Metal</EM></DIV> <DIV><EM>]</EM></DIV> <DIV><EM>;</EM></DIV> <DIV>&nbsp;</DIV> <DIV>Or, if you are using Data Manager, you can simply replace values:</DIV> <DIV>&nbsp;</DIV> <DIV><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="zar_0-1674389539621.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/98568iA744EA92F13EE882/image-size/medium?v=v2&amp;px=400" role="button" title="zar_0-1674389539621.png" alt="zar_0-1674389539621.png" /></span> <P>&nbsp;</P> <span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="zar_1-1674389574258.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/98569i09B8211CA10D22EA/image-size/medium?v=v2&amp;px=400" role="button" title="zar_1-1674389574258.png" alt="zar_1-1674389574258.png" /></span> <P>&nbsp;</P> </DIV> Sun, 22 Jan 2023 12:13:01 GMT https://community.qlik.com/t5/App-Development/Merging-Single-Filed-values-into-One/m-p/2028564#M84749 zar 2023-01-22T12:13:01Z Re: Merging Single Filed values into One https://community.qlik.com/t5/App-Development/Merging-Single-Filed-values-into-One/m-p/2028565#M84750 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/154754">@zar</a><FONT color="#009845"><U>zar </U></FONT></P> <P>ThankYou for providing the solution.&nbsp;</P> Sun, 22 Jan 2023 12:17:58 GMT https://community.qlik.com/t5/App-Development/Merging-Single-Filed-values-into-One/m-p/2028565#M84750 jyoshna 2023-01-22T12:17:58Z