12 Replies Latest reply on Mar 23, 2020 4:02 AM by Stefan Reinhardt

    IDQ rule 'Attribute Mandatory validation' - define an attribute value language?

    Margot Emmers Seasoned Veteran

      Good morning all,

       

      I need some advice on changing an IDQ rule.

      IDQ rule : 'Attribute Mandatory validation'

      This standard IDQ rule will show in the 'Quality message' all missing Attribute values (for us in 4 languages) defined on a Mandatory attribute.

      I would like to adjust this IDQ rule, define an attribute value language, so I will only get notifications of missing attribute values in that specific language.

      How can I define this?

      I can select fields in the IDQ rule but not define any language on those fields?

      What did I test:
      - on level Input port 'inLanguage' in field column replace 'language' by 'Dutch' - result is not limited to information of only the attribute values of this language


      - on level Input port 'inLanguage' in field column replace 'language' by '19' - result is not limited to information of only the attribute values of language Dutch


      - on level Input port 'inLanguage' in field column replace 'language' by 'Langage of the value'

       

      Reason:

      1. To get directly more specific information per language what is missing

      2. The 'Quality message' is restricted in characters. If you have a lot of mandatory values defined not all information is contained in the Quality message (cut off). If I'm able to define a language only the information of that specific language will be contained, to get a total and more specific overview.

       

      See example below. The field InLanguage

       

      Perspective ‘Attribute assignment (items)’
      Structure: Eriks Group Taxonomy
      Structure group: EC011187
      GRID: GR0000000185781

      Start off : 6 mandatory values : attribute values for all languages contain values

      Run IDQ rule ‘Mandatory Attribute values (Dutch)’ over GRID
      Result : No error = OK

      Remove Attribue value (Dutch, DEFAULT) on Attribute ‘Material | EF002169’

      Run IDQ rule ‘Mandatory Attribute values ’ over GRID
      Result : 1 line – Mandatory value (Dutch) is missing on attribute Material | EF002169’ = OK

      Remove Attribue value (French, DEFAULT) on Attribute ‘Material | EF002169’

      Run IDQ rule ‘Mandatory Attribute values (Dutch)’ over GRID
      Result : 2 lines – Mandatory value (Dutch, French) is missing on attribute Material | EF002169’

      Here I would like to have just one result, only information when Attribute value (Dutch) is missing!

       

      Thanks for your help on this!

       

      Kind regards,

      Margot Emmers