Skip to Content
author's profile photo Former Member
Former Member

MDM fields and tables

In MDM i want to import data in such a way that: if in Data manager , i select a country eg. India then it will show the states in states from India only and not states of other countries.(whiich are in the data sheet which is to be imported).after that the cities will popukate in city field accordingly.please reply asap.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 13, 2007 at 03:32 PM

    Hi Ankit,

    Define a Qualified table and Country as Non Qualifier and define States as Qualifier - Multivalued Flat lookups. Store States in Flat lookups. States should be loaded with a separator (Comma or Semi colon).When you load the data you can see states only to the country.

    2nd option

    =======

    Instead of Multivalued Flat lookups ,you can also define Multivalued Text block.

    I prefer option 1 will be better.

    Thanks

    Ganesh Kotti

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2007 at 11:49 AM

    Hi Ankit,

    There are several ways of designing a repository but these can be efficiently realised in 2 ways.

    I agree with ganesh on his suggestion but even their is a better work around

    <b>Type1</b>

    U can have states as a multivalued qualifier and proceed the way ganesh have advised.

    <b>Type2:</b>

    U can make use of nested lookups even .

    <u>step1:</u>

    What u need to do is make country as a <i>lookup[flat]</i> in the main table and can have country and state inside them.

    <u>step2:</u>

    declare state as another <i>lookup[flat]</i> insidecountry look up table.

    <i>step3:</i>

    Inside state have city as another <i>lookup[flat].</i>

    <i>step4:</i>

    while importing start with the lowest lookup and then proceed a level up.

    after importing the records in the data manger go for the table country u can find 3 drop downs and for a particular country u fill find the valid set of states and cities and u can view them.Lookup[Flat] are suggested because they are used when the values are a valid set and search can be made faster.

    Please reward points if u find thes blog helpful.

    Thanks & Regards

    Deepankar Pandit

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.