I have source files to build dimension lists like Territory and Product with hierarchical relationships which have hierarchy level column. I want to build Territory and product dimension lists by importing the respective files and filter by lowest hierarchy level (a number that show the level) during import definition. Is it possible?
For example I have a product file with below columns, I want to load Products that are equal to Hier Level ‘3’.
Hello Sudhakar,
At the moment, Pigment does not support filtering data directly within the import configuration. However, depending on your use case, you can import the full dataset and then use Pigment’s in-app filtering capabilities to work with the specific hierarchy level.
Alternatively, you might consider using the Dimension Scope option to define how the import behaves. You can find more details about this in this Community article.
Let us know if you'd like help setting this up or if you have any other questions.
Best regards,
Thanks Luiza
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.