Add dimension to pivot table automatically by split fields from data manager

[Sri4]

Hi ,

I have loaded table from the data manager .Sample data mentioned below. I split the filed into multiple fields by delimiter. I want to create a pivot table and add dimensions automatically into my pivot table if split fields increase from data manager.  

Table:

Path

C/forums/community

D/ Qliksense

D/Qliksense/ Sense/files/documents

[Or]

I don't think there's a way to automatically add new dimensions to an existing object, barring use of Automation and/or API.

You might be able to work around this by creating dummy dimensions with a single value (e.g. Load 'Dummy' as Field6 autogenerate(1)), adding them to the pivot, and using a show/hide condition to only show the ones that have a value other than 'Dummy'. You could add an If statement in your script to only do this if e.g. Field6 does not exist yet, presumably, preventing the Dummy value from getting in the way of real values.