Look up tables

[Former Member]

Hi MDM Guru's,

Can we have lookup table (flat) in a Look uptable (flat) for a Main table in a Repository or Can we use any other type of lookup table?

Please guide me.

Thanks in advance

Cheers

Srihari Reddy

[Former Member]

Hi Srihari,

Yes, we can have lookup [Flat] table under another lookup[Flat] table.

But lookup[Taxonomy] and lookup[Qualified] tables are possible under main tables only, not possible

under lookup tables.

Thanks,

Narendra

[Former Member]

Hi All,

Thanks for the updates. Allotted points.

Cheers

Srihari Reddy

[Former Member]

Hi Srihari,

Can we have lookup table (flat) in a Look uptable (flat) for a Main table in a Repository or Can we use any other type of lookup table?

- Yes ,You can have lookup tables within a Lookup table.

Most of the times you can have a requirement wherein you have created a lookup table say Units, and you have a main table field pointing to thhis lookup table.But you may also require to reuse this lookup table values within another lookup table say you have a table Alternate Unit of measure wherein you have different other fields but you also need to lookup into the units table values.Here you can reuse the craeted lookup table by just creating a lookup field in the alternate unit of measure table pointing to the lookup table Units.

So this will create a Lookup within a lookup called as nested lookup with a functional sense to it.

To answer your other question.

You need not have just a nested flat lookup you can also have a Flat lookup within a Qualified lookup and so on.

Hope It Helped

Thanks & Regards

Simona Pinto

[former_member208981]

Hi Srihari,

Yes we can have multilevel of lookup tables related to the main table. This concept is called Nested Lookups.

Nested Lookup table: Nested look up tables are used when more than one lookup table are linked to the other. This way, the main table is indirectly linked to all the subsequent lookups, i.e. the nested lookups are related to the main table.

For Example:

Say you have a list of Manufacturers in your main table and want to maintain their address. You can use the nested lookup concept.

In Main table:

Manufacturer_ID , Manufacturer_Country [Type = Lookup Flat] : Its lookup table = LT_Country

In LT_Country lookup table: Country, Zone, City [Type = Lookup Flat] :Its lookup table = LT_City

In LT_City lookup table: City, Pincode [Type = Lookup Flat] : Its lookup table = LT_Pincode

In the above example we see Nested Lookup table concept.

In case of importing, you have to use the Partition fields concept and import the records.

Thanks & Regards,

Priti.

[Former Member]

Hi Srihari,

Yes you can have a nested lookup linked to your main table.

Eg. Main Table Country Look up

Country Look up Table

Fields : Country (Field) and State Look up

State Look up Table

Fields : State (Field) and City Look up

City Look up Table

Field : City Field

Hope it helps.

Thanks,

Minaz