Generating new dimension and values according to the folders paths

[#1]

Hello everyone!

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

My load script has this structure:

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:

Can someone share the solution with me?

Thanks in advanced!

[anbu1984 · Accepted solution]

for each vFolder ...

NewDim:

Load

$(vFolder) As NewDimension

From

[$(vFolder)...]

....

where RowNo() < 1;

[#3]

Hi, Anbu

I've already tried it.

It doesn't work, because creates only one value.

Tks

[Anonymous]

you are missing the next statement below the execution of the load statement?!

[maxgro]

Stefan answer seems ok

for each vFolder in 'Brand 1', 'Brand 2'

  NewDim:

  Load

  '$(vFolder)' As NewDimension

  AutoGenerate 1;

next;

[#6]

Oh, that's right

I've missed the next statement.

It works!

Thanks!

[#7]

You're right, Stefan

I've missed it.

thanks!

[#8]

You're righ, Massimo

I've missed. Now works fine.

tks!