topic Merging multiple rows with values into 1 row with different name in App Development https://community.qlik.com/t5/App-Development/Merging-multiple-rows-with-values-into-1-row-with-different-name/m-p/1646924#M48237 <P>Hi All,</P><P>This is my Table</P><P>Type&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Views</P><P>Apple&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10</P><P>Apple IOS&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;15</P><P>Chrome&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10</P><P>Google&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 15</P><P>&nbsp;</P><P>I want to convert above table in QlikView into Table like below while loading</P><P>Type&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Views</P><P>Apple IOS&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;25</P><P>Google Chrome&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;25</P><P>&nbsp;</P><P>Any help is appreciated.</P> Sat, 16 Nov 2024 04:07:03 GMT Naushad07 2024-11-16T04:07:03Z Merging multiple rows with values into 1 row with different name https://community.qlik.com/t5/App-Development/Merging-multiple-rows-with-values-into-1-row-with-different-name/m-p/1646924#M48237 <P>Hi All,</P><P>This is my Table</P><P>Type&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Views</P><P>Apple&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10</P><P>Apple IOS&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;15</P><P>Chrome&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10</P><P>Google&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 15</P><P>&nbsp;</P><P>I want to convert above table in QlikView into Table like below while loading</P><P>Type&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Views</P><P>Apple IOS&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;25</P><P>Google Chrome&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;25</P><P>&nbsp;</P><P>Any help is appreciated.</P> Sat, 16 Nov 2024 04:07:03 GMT https://community.qlik.com/t5/App-Development/Merging-multiple-rows-with-values-into-1-row-with-different-name/m-p/1646924#M48237 Naushad07 2024-11-16T04:07:03Z Re: Merging multiple rows with values into 1 row with different name https://community.qlik.com/t5/App-Development/Merging-multiple-rows-with-values-into-1-row-with-different-name/m-p/1646926#M48238 <P>May be using Mapping Load to cleanse your data</P><P><A href="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/LoadData/data-cleansing.htm" target="_self">Data cleansing</A>&nbsp;</P> Thu, 14 Nov 2019 13:01:50 GMT https://community.qlik.com/t5/App-Development/Merging-multiple-rows-with-values-into-1-row-with-different-name/m-p/1646926#M48238 sunny_talwar 2019-11-14T13:01:50Z