How to syndicate based on Condition on Qualifier Table field values

[Former Member]

Hi All,

I have a scenario where I am struck with syndication logic: Does it possible to acheive?

I have a Qualifier Look up [Multivalued] Table:

QUAL Table

---NAME

---UpdateTime Stamp

Main table has

MDM ID

QUAL Table

Record Update Time Stamp

I have a values in MDM Data Manager as 1,((AA,9/16/2010 14:05:20),(BB,9/16/2010 14:05:20)),9/16/2010 14:05:20

I dont want to syndicate data if the NAME of the Qualifier Table is AA and Update Time stamp equals to RecordUpdateTime Stamp of NAME=AA..

Is it possible? How can I achieve this?

Regards,

Rajeev

[Former Member · Accepted solution]

Hi Rajeev,

Over here problem is while updating qualified table data AA and BB together MDM system will update same date and times for both qualified data

You can acheive this by setting field name equal BB value in free form search or search parameter and tick filter qualified link in map properties will syndicate only BB value but in this case problem is you need create seprate map for each conditional qualified table data

Thanks,

Jignesh Patel

[Former Member · Accepted solution]

Hi,

Is it possible to exclude one Qualifier from the list of Qualifiers

I have a table with one Qualifer table

MDMID, Qualifer (Name,Code)

111,Qualifeir ((AAA,01),(BBB,02))

I want to syndicate this record with out syndicating AAA value.. Is it possible?

i.e., 111,(BBB,02)

MDMID, Qualifer (Name,Code)

111,Qualifeir ((AAA,01),(BBB,02))

222,Qualifeir ((AAA,01),(CCC,03))

333,Qualifeir ((DDD,04),(EEE,05))

Then

111,(BBB,02)

222,(CCC,03)

333,(DDD,04),(EEE,05)

How can I achieve this? I tried using Qulifier filter but still its not working.. Any inputs please.

Thanks

Rajeev

[Former Member · Accepted solution]

Hi Rajeev,

1.Check the filter qualified links option in map properties.

2. Select your seach values in left side .

3. map the source and destination fields.

4.Check the destination preview tab,you will note see any AAA record whereas in record section i.e. upper side portion you will see all the qualified records.

So dont confuse by checking only the records pane.Just check at the destination preview tab what records are u getting.

Please check at your end and revert back with your findings.

Thanks,

Sudhanshu

[Former Member · Accepted solution]

Hi Rajeev,

To exclude the qualifier data is not possible, The Qualified filter option allow to filter the qualifier data i.e. which ever data you select in search pane will display only those records

Thanks,

Jignesh Patel