This content has been marked as final. Show 7 replies
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!