topic Re: Row wise users Splitting in QlikView https://community.qlik.com/t5/QlikView/Row-wise-users-Splitting/m-p/1258830#M860136 <HTML><HEAD></HEAD><BODY><P>Then, Share that expression and flag your response as Correct answer it demonstrates and useful to others like Us <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 17 Jan 2017 07:06:41 GMT Anil_Babu_Samineni 2017-01-17T07:06:41Z Row wise users Splitting https://community.qlik.com/t5/QlikView/Row-wise-users-Splitting/m-p/1258825#M860131 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have excel with folder name and user details.</P><P>The problem here is file name and the corresponding users are in one single row. But I need them to be splitted per row.</P><P></P><P>ex: Actual</P><P>Folder,user</P><P>Fol_001,sa\pr full control</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sa\pqeer-akjha Allow&nbsp; FullControl</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sa\pqeeer Allow&nbsp; FullControl</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sa\pqwqwr Allow&nbsp; FullControl</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sa\prded Allow&nbsp; FullControl</P><P>requirement :</P><P>Folder,user</P><P>Fol_001,sa\pr full control </P><P>&nbsp; Fol_001,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sa\pqeer-akjha Allow&nbsp; FullControl</P><P>Fol_001,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sa\pqeeer Allow&nbsp; FullControl</P><P>&nbsp;&nbsp;&nbsp; Fol_001,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sa\pqwqwr Allow&nbsp; FullControl</P><P>&nbsp;&nbsp; Fol_001,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sa\prded Allow&nbsp; FullControl</P><P></P><P>Kindly assist</P><P></P><P>Thanks,</P><P>Prajna</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Row-wise-users-Splitting/m-p/1258825#M860131 2020-11-25T16:16:04Z Re: Row wise users Splitting https://community.qlik.com/t5/QlikView/Row-wise-users-Splitting/m-p/1258826#M860132 <HTML><HEAD></HEAD><BODY><P>I Assume, You must have like below for inline memory</P><P></P><P>LOAD * Inline [</P><P>Folder,user</P><P>Fol_001,sa\pr full control</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; , sa\pqeer-akjha Allow&nbsp; FullControl</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; , sa\pqeeer Allow&nbsp; FullControl</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp; sa\pqwqwr Allow&nbsp; FullControl</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp; sa\prded Allow&nbsp; FullControl</P><P>];</P><P></P><P>Then use preceding load like below / Post Real and Live Data to seen</P><P></P><P>LOAD&nbsp; <STRONG>if(Folder= '', 'Fol_001',Folder) as Folder</STRONG>, user Inline [</P><P>Folder,user</P><P>Fol_001,sa\pr full control</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; , sa\pqeer-akjha Allow&nbsp; FullControl</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; , sa\pqeeer Allow&nbsp; FullControl</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp; sa\pqwqwr Allow&nbsp; FullControl</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp; sa\prded Allow&nbsp; FullControl</P><P>];</P><P></P><P>OR</P><P></P><P><SPAN style="color: #545454; font-family: arial, sans-serif; font-size: small;"><STRONG>if(<SPAN style="font-size: 13.3333px;">Folder</SPAN>= '' or isnull (<SPAN style="font-size: 13.3333px;">Folder</SPAN>), </STRONG></SPAN><STRONG><SPAN style="color: #6a6a6a; font-family: arial, sans-serif; font-size: small;">Previous</SPAN><SPAN style="color: #545454; font-family: arial, sans-serif; font-size: small;">(<SPAN style="font-size: 13.3333px;">Folder</SPAN>),<SPAN style="font-size: 13.3333px;">Folder</SPAN>) as <SPAN style="font-size: 13.3333px;">Folder</SPAN></SPAN></STRONG></P><P></P><P>OR Look this thread by using Transformation <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P><A href="https://community.qlik.com/thread/96702">Fill empty cells with value from "above"</A></P></BODY></HTML> Tue, 17 Jan 2017 07:01:27 GMT https://community.qlik.com/t5/QlikView/Row-wise-users-Splitting/m-p/1258826#M860132 Anil_Babu_Samineni 2017-01-17T07:01:27Z Re: Row wise users Splitting https://community.qlik.com/t5/QlikView/Row-wise-users-Splitting/m-p/1258827#M860133 <HTML><HEAD></HEAD><BODY><P>found the solution <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 17 Jan 2017 07:02:45 GMT https://community.qlik.com/t5/QlikView/Row-wise-users-Splitting/m-p/1258827#M860133 2017-01-17T07:02:45Z Re: Row wise users Splitting https://community.qlik.com/t5/QlikView/Row-wise-users-Splitting/m-p/1258828#M860134 <HTML><HEAD></HEAD><BODY><P>Thanks, I used subfield.It worked <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 17 Jan 2017 07:03:43 GMT https://community.qlik.com/t5/QlikView/Row-wise-users-Splitting/m-p/1258828#M860134 2017-01-17T07:03:43Z Re: Row wise users Splitting https://community.qlik.com/t5/QlikView/Row-wise-users-Splitting/m-p/1258829#M860135 <HTML><HEAD></HEAD><BODY><P>Provide proper sample data.</P><P>you can achieve this by using below combination in script.</P><P>Resident Load, Peek/Previous, IsNull()</P></BODY></HTML> Tue, 17 Jan 2017 07:04:09 GMT https://community.qlik.com/t5/QlikView/Row-wise-users-Splitting/m-p/1258829#M860135 MK_QSL 2017-01-17T07:04:09Z Re: Row wise users Splitting https://community.qlik.com/t5/QlikView/Row-wise-users-Splitting/m-p/1258830#M860136 <HTML><HEAD></HEAD><BODY><P>Then, Share that expression and flag your response as Correct answer it demonstrates and useful to others like Us <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 17 Jan 2017 07:06:41 GMT https://community.qlik.com/t5/QlikView/Row-wise-users-Splitting/m-p/1258830#M860136 Anil_Babu_Samineni 2017-01-17T07:06:41Z