7 Replies Latest reply: Sep 26, 2014 2:49 PM by Marcelo Hernandes RSS

    Generating new dimension and values according to the folders paths

    Marcelo Hernandes

      Hello everyone!

       

      Is it possible to generate new dimension and values according to the folders paths?

       

      My load script has this structure:

      ScreenShot061.jpg

      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.

       

      And finally, I'd get a table like this:

      ScreenShot062.jpg

      Can someone share the solution with me?

       

      Thanks in advanced!