Avatar

Correct answer by
Community Advisor

Hi,

 

If the join cardinality is 'multiple' on the schema, you should be presented with a wizard to configure the pivot in the select part of the query, e.g. how many rows to pivot into cols.

If the link isn't defined in schema, the same can be done with an enrichment.

For filtering, no pivot is necessary- just use a filtering dimension or an exists clause.

 

Thanks,

-Jon

View solution in original post