Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
bob17577
Contributor II
Contributor II

Load Enumeration Items Dynamically Based On Other Element

Hi there,

 

I am working on a entity that needs a dropdown box with multiple items, and I need to load different items based on the value of a different field. For example, available car models will depend on the car make, e.g. only civic, accord will be available for car make Honda, and only cruze and volt will be available for car make Chev, etc. is there anyway that can be done in the MDM data model?

 

Please help, thanks a lot in advance.

 

Bob

Labels (2)
3 Replies
Anonymous
Not applicable

Hello,

Could you please elaborate your case with an example with input and expected output values?

Best regards

Sabrina

bob17577
Contributor II
Contributor II
Author

Hi thanks for your reply. here is my case ( I am using Talend MDM Platfrom 6.4):

I need to make a dropdown box for product sub type so that the user can choose, so I created that in the data model with a Custom type, SubType, and added enumeration items, that is all good. But the requirements are, the available enumeration items will depend on the other element, which is Type (with string value). That means, e.g. for the Type of A, the available SubType must be a, b, c, d. and for the Type B, the available SubType must be only a and b.

 

I have tried to look at the visible rule, but the visible rule only applies to the level of Element, not working on the lower level, then I tried just load everything to the dropdown box, then use validation rule to make sure the right type of SubType is chosen and saved, but the validation rule seems only takes patterns, not allowing me to write if..else there, or no idea how that can be done.

 

 I am still new to Talend so not sure how that can be done in Talend, Thanks for your help

 

I am loading some screenshots...

bob17577
Contributor II
Contributor II
Author

Also, I tried to create multiple SubType element, then use visible rule to show the right one and hide anything else. It looks good in web ui, but I cannot implement the search capability, i.e. search fields are not working.


SubTypeItems.png