topic Generating new dimension and values according to the folders paths in QlikView https://community.qlik.com/t5/QlikView/Generating-new-dimension-and-values-according-to-the-folders/m-p/707875#M671672 <HTML><HEAD></HEAD><BODY><P>Hello everyone!</P><P></P><P>Is it possible to generate new dimension and values according to the folders paths? </P><P></P><P>My load script has this structure:</P><P><IMG alt="ScreenShot061.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/67752_ScreenShot061.jpg" /></P><P>What I looking for: for example, if the data is coming from the folder 'Brand 1', I'd get a new dimension with the 'Brand 1' value. And, if it's coming from the folder 'Brand 2', I'd get the 'Brand 2' value in the new dimension. And so on.</P><P></P><P>And finally, I'd get a table like this:</P><P><IMG alt="ScreenShot062.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/67753_ScreenShot062.jpg" /></P><P>Can someone share the solution with me?</P><P></P><P>Thanks in advanced!</P></BODY></HTML> Fri, 26 Sep 2014 16:30:26 GMT 2014-09-26T16:30:26Z Generating new dimension and values according to the folders paths https://community.qlik.com/t5/QlikView/Generating-new-dimension-and-values-according-to-the-folders/m-p/707875#M671672 <HTML><HEAD></HEAD><BODY><P>Hello everyone!</P><P></P><P>Is it possible to generate new dimension and values according to the folders paths? </P><P></P><P>My load script has this structure:</P><P><IMG alt="ScreenShot061.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/67752_ScreenShot061.jpg" /></P><P>What I looking for: for example, if the data is coming from the folder 'Brand 1', I'd get a new dimension with the 'Brand 1' value. And, if it's coming from the folder 'Brand 2', I'd get the 'Brand 2' value in the new dimension. And so on.</P><P></P><P>And finally, I'd get a table like this:</P><P><IMG alt="ScreenShot062.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/67753_ScreenShot062.jpg" /></P><P>Can someone share the solution with me?</P><P></P><P>Thanks in advanced!</P></BODY></HTML> Fri, 26 Sep 2014 16:30:26 GMT https://community.qlik.com/t5/QlikView/Generating-new-dimension-and-values-according-to-the-folders/m-p/707875#M671672 2014-09-26T16:30:26Z Re: Generating new dimension and values according to the folders paths https://community.qlik.com/t5/QlikView/Generating-new-dimension-and-values-according-to-the-folders/m-p/707876#M671673 <HTML><HEAD></HEAD><BODY><P>for each vFolder ...</P><P>NewDim:</P><P>Load </P><P>$(vFolder) As NewDimension</P><P>From</P><P>[$(vFolder)...]</P><P>....</P><P>where RowNo() &lt; 1;</P></BODY></HTML> Fri, 26 Sep 2014 18:14:35 GMT https://community.qlik.com/t5/QlikView/Generating-new-dimension-and-values-according-to-the-folders/m-p/707876#M671673 anbu1984 2014-09-26T18:14:35Z Re: Generating new dimension and values according to the folders paths https://community.qlik.com/t5/QlikView/Generating-new-dimension-and-values-according-to-the-folders/m-p/707877#M671674 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hi, Anbu</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I've already tried it.</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">It doesn't work, because creates only one value.</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Tks</P></BODY></HTML> Fri, 26 Sep 2014 18:30:56 GMT https://community.qlik.com/t5/QlikView/Generating-new-dimension-and-values-according-to-the-folders/m-p/707877#M671674 2014-09-26T18:30:56Z Re: Generating new dimension and values according to the folders paths https://community.qlik.com/t5/QlikView/Generating-new-dimension-and-values-according-to-the-folders/m-p/707878#M671675 <HTML><HEAD></HEAD><BODY><P>you are missing the next statement below the execution of the load statement?!</P></BODY></HTML> Fri, 26 Sep 2014 18:38:38 GMT https://community.qlik.com/t5/QlikView/Generating-new-dimension-and-values-according-to-the-folders/m-p/707878#M671675 Anonymous 2014-09-26T18:38:38Z Re: Re: Generating new dimension and values according to the folders paths https://community.qlik.com/t5/QlikView/Generating-new-dimension-and-values-according-to-the-folders/m-p/707879#M671676 <HTML><HEAD></HEAD><BODY><P>Stefan answer seems ok</P><P></P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P><SPAN style="font-size: 8pt;">for each vFolder in 'Brand 1', 'Brand 2'</SPAN></P> <P><SPAN style="font-size: 8pt;">&nbsp; NewDim:</SPAN></P> <P><SPAN style="font-size: 8pt;">&nbsp; Load</SPAN></P> <P><SPAN style="font-size: 8pt;">&nbsp; '$(vFolder)' As NewDimension</SPAN></P> <P><SPAN style="font-size: 8pt;">&nbsp; AutoGenerate 1;</SPAN></P> <P><SPAN style="font-size: 8pt;">next;</SPAN></P> </TD></TR></TBODY></TABLE></BLOCKQUOTE><P><IMG __jive_id="67775" alt="1.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/67775_1.png" style="width: auto; height: auto;" /></P></BODY></HTML> Fri, 26 Sep 2014 18:45:50 GMT https://community.qlik.com/t5/QlikView/Generating-new-dimension-and-values-according-to-the-folders/m-p/707879#M671676 maxgro 2014-09-26T18:45:50Z Re: Generating new dimension and values according to the folders paths https://community.qlik.com/t5/QlikView/Generating-new-dimension-and-values-according-to-the-folders/m-p/707880#M671677 <HTML><HEAD></HEAD><BODY><P>Oh, that's right</P><P></P><P>I've missed the next statement. </P><P></P><P>It works!</P><P></P><P>Thanks!</P></BODY></HTML> Fri, 26 Sep 2014 18:47:57 GMT https://community.qlik.com/t5/QlikView/Generating-new-dimension-and-values-according-to-the-folders/m-p/707880#M671677 2014-09-26T18:47:57Z Re: Generating new dimension and values according to the folders paths https://community.qlik.com/t5/QlikView/Generating-new-dimension-and-values-according-to-the-folders/m-p/707881#M671678 <HTML><HEAD></HEAD><BODY><P>You're right, Stefan</P><P></P><P>I've missed it.</P><P></P><P>thanks!</P></BODY></HTML> Fri, 26 Sep 2014 18:48:35 GMT https://community.qlik.com/t5/QlikView/Generating-new-dimension-and-values-according-to-the-folders/m-p/707881#M671678 2014-09-26T18:48:35Z Re: Generating new dimension and values according to the folders paths https://community.qlik.com/t5/QlikView/Generating-new-dimension-and-values-according-to-the-folders/m-p/707882#M671679 <HTML><HEAD></HEAD><BODY><P>You're righ, Massimo</P><P></P><P>I've missed. Now works fine.</P><P></P><P>tks!</P></BODY></HTML> Fri, 26 Sep 2014 18:49:38 GMT https://community.qlik.com/t5/QlikView/Generating-new-dimension-and-values-according-to-the-folders/m-p/707882#M671679 2014-09-26T18:49:38Z