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

Is it possible to filter records during import to Qualified table.

Hi Team,

I have a Material Repository which has a Qualified Table named -"Material Description".and other fields .

The Fields in the Qualified table are : Country (No Qualifier), Language(No Qqualifier), Description (Yes Qualifier), Translation Indicator(Yes Qualifier, Boolean value ) .

While importing maintable record is it possible that if the Translation Indicator value in incoming file is " Y" only then the qulaified table import will happen . If Translation Indicator value is "N" then other fields in Main Table will get imported but no import will happen in Qualified table .

Please reply .

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 08, 2010 at 06:58 AM

    Hi ,

    This is not possible .

    First thing we have to use workflow to check the values as there is no possibility to check Y and N values in import.

    Second ,i dont think we can discard particular qualified records through validation we can discard whole record not only qualified records.

    Thanks,

    Sudhanshu

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 08, 2010 at 08:24 AM

    Hi Prabuddha,

    As per my understanding, i feel that you need to have new source structure which should have all your fields of Qualified Table named -"Material Description" and one field of main table(Display field) say Material Number on the basis of which you need to import your qualified table fields.

    Scenario: As you have already main table records (all other fields) except your qualified table records imported in your main table using some other map and source structure which does not have qualified table fields.

    Now in order to import Qualified table with condition Translation Indicator value, you need to make use of MDM Workflow.

    Start(Checkout)>Branch Step(based no conditon(validation) if Translation Indicator value = Y)>Stop1(CheckIn) Record Saved.

    -


    > if Translation Indicator value = N--->Stop2(Rollback) Records not committed(saved) in MDM

    Use this workflow trigger action on Record Import and use this workflow during import using configuration options of Import Manager and then Saved this in your Import Map. So in this manner, you will get desired result.

    Note: Even you can use the same source structure with two maps; in 1st map, map all the fields of your source structure except Qualified tables fields. Now for 2nd map, map only Qualified table (all fields Non-Q and Q) with only one main table display field like Material Number which should use MDM Workflow as suggested above.

    Regards

    Mandeep Saini

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Roy

      to me using MDM workflow and rolling out the records if the boolean qualifier is No would be further complicating for the MDM users/data stewards. Instead we can try to build a logic in the source file preparation or middleware to suppress the records based on above condition.

      thanks-Ravi

  • author's profile photo Former Member
    Former Member
    Posted on Jul 19, 2011 at 10:03 PM

    Thanks all

    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.