Filtering a tuple table fields

[Former Member]

Hello All,

     We have a requirement where we need to syndicate the Main table records by filtering a tuple table field (a lookup field in a tuple table) which is inside a nested main table field. Please find the below structure

     Product (Main table)

           - Material Number (Another Main table)

                    -  ECC(Tuple table)

                         - Country of Origin (look up table)

Thus in the above I would need to filter certain values for Country of Origin field to syndicate the records from the Product Main table. When I tried using free form search , I was not able to find the fields present in the ECC tuple table. Can you please provide some inputs/solutions for this?

Thanks,

Arun

[Former Member]

Hi Ankush,

When I try to create an expression in the Product main table, the fields of the tuple table are not appearing in the expression formula editor. In the expression editor, when I look up the fields I get Material Number --> ECC but after this I get only as [Record] and no other fields which are available in the tuple table are appearing in it.

But when I create an expression at the GTIN table, I could find the ECC table and all its related fields in the expression editor.

Thanks,

Arun

[Former Member]

Hi Arun,

I am asking you to create the expression on the field which is Lookup[Main] type(say A field in Product table is Lookup[Main] type).

I am saying that field A would be storing the value of country, for example INDIA, USA, JAPAN etc..

Then you can write expression like:

Has Any Chars(A, "INDIA")

and set Expression value to true, then system will filter the records which contain INDIA only. Similarly you can add few other countries also if you have the requirement. This would solve your purpose of filtering the data based upon the country of origin.

This is just an example and you need to try on these lines to get the expression which will fulfil your requirement. You can also let me know the field and few values so that i could help you in creating the expression.

Thanks and Regards,

Ankush Bhardwaj

[Former Member]

Hi Ankush,

Yes, we are using Look up [Main] to reference the Material Number Main table to the Product Main table.

Please find the structure below

Product  (Main table) which looks up another Main table Material Number (Main table)

Material Number (Main Table) has a field which points to a tuple table ECC

ECC (Tuple table) has a field Country of Origin which is a lookup flat.

My requirement here is to filter for certain values of Country of Origin field from the Product [Main table] for automatic syndication

We have made sure the tuple fields are search enabled in Console.As the ECC tuple table is under Material Number table, this field doesn't come up in Search tab for Product Main table .We are not able to get the fields for ECC tuple table in the free form search when we try it from Product Main table.

Thanks,

Arun

[Former Member]

Hi Arun,

I understand your concern now. Since Syndication map is for different main table, those tuple fields are not appearing in search tab for Products table.

Since values must be appearing in the Lookup[Main] field, can you try executing some expression on the values of this field?

Expression could be that value should contain certain countries of origin and then only that record should appear in the selected records to be syndicated.

Can you please give me an example of Data being stored in that Lookup[Main] field so that i could help you in creating the Expression? Kindly let me know and in parallel, you can also try creating the expression. This should solve your problem of filtering the data.

Kindly let me know. Thank you.

Regards,

Ankush Bhardwaj

[Former Member]

Hi Arun,

Can you please let me know how are you using these two main tables? Are you using Lookup[Main] to reference Material Number main table from other main table Product?

Also kindly check that the fields through which this tuple fields are used, should all be search enabled in MDM console properties. Then only Member Fields will appear under Search Tab. Please check this and let me know the results. Also kindly describe the structure so that finding solution to your requirement is a bit easier.

Thanks and Regards,

Ankush Bhardwaj