Generating new dimension and values according to the folders paths
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.