Skip to Content
avatar image
Former Member

Validation and assignment

Hi Experts,

There are two fields under Validation tab in data manager.

One is Callable another is branch value.

1)Could you explain me the function of those two fields and

2) What is the purpose of assignmentn tab in data manager.

Thanks and regards,

Shalini

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 10, 2008 at 01:05 PM

    Thanks Saurabh. But I have seen in my repository there is a field city. I ahave written same exp. which you provided and choose Field city also. But in the data manager Mumbai is not appearing in place of blank city.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Shalini,

      Once you create an assignment under the assignment tab in data manager. then you have to call that particular assignment against the record in record pane.

      Choose a particular record in which the city field is blank and right click on the record and execute the assignment which you have made.

      After the succeful execution of the assignment, you can see the field value mumbai will be there.

      IF (IS_NULL (City),u201DMumbaiu201D, City)

      while writing the above assignment, make sure that City you choose from the drop downlist of field in expression editor and mumbai you have to write manually using double quotes.It is alwats recomended to choose the field name from the drop down list while writing the expressions.

      The above exression is the way to understand the functionality of MDM expression, you can perform any logic as per the requirement.

      here i am giving one more example to better understanding:

      Suppose in your repository, there are three field Name, First name and Last Name.

      you have to add the First name and Last Name and assign the value in the Name field. then you can make the assignment on field Name and write you expression like as:

      CONCAT(First name,Last Name)

      when you execute the expression manually on the record then you will find the full name value in the "Name" field.

      you can also execute the assigmnet on a multiple records at a time.Just select all those record on which you want to perform the assignment and execute the assignment.

      there are two ways to call the assignment, one is you have to execute manually and second, you can call the assignment using MDM workflow.

      Hope this will help you and clear your doubt.

      TNR,

      Saurabh...

      Reward if found helpful.

  • avatar image
    Former Member
    Jun 10, 2008 at 12:05 PM

    Hi Shalini,

    If you make Validation as Callable then you can call that Validation Expression in another validation

    E.g. Validation1 marked as callable

    Validation2 needs same expression one used in first Validation along with some additional conditions then instead of writing entire validation1 into Validation2 you can directly call that Validation into Validation2.

    Branch enables you to create the Validations on Attributes and will be active only if you have Taxonomy in your repository.

    Branch cannot be executed separately. Always parent validation executes first and then Branch.

    When you create the Branch expression it first ask for the category to select and all the attributes of that category will be available for writing expressions.

    Assignments are used to populate values in the fields based on some conditions like based on values of other fields etc

    Regards,

    Jitesh Talreja

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 10, 2008 at 12:06 PM

    Hello Shalini,

    Under the validation tab,

    Callable is the property for a perticular validation which you have made sothat you can use this validation in another validation. here reusability comes into the picture.

    To make the validation callable in other validation, set the property callable=yes.

    If you set the property say "yes" then you can see the perticular validation name in the function dropdown list in the expression editor to call in another validation.

    Branch Value:The taxonomy lookup field value on which a branch branches.you can write the validations on attributes of taxonomy table.to use this branch value, you have to "Add Branch" option if you want to write validations on attributes and its value.and this Add branch validation always will be a child validation of any validation on which you want to perform.

    when you use add brach option then Branch value option will be enable and you can select the category here on which you want to perform the validation and alsio you can see the option "Attributes" and "text Values" drop down list will be enabled to wirte the validation on these in Expression editor.

    Validations: Validations in MDM are expressions that return a Boolean success or failure result.

    For Example: validation IS_NOT_NULL (Product ID) checks if the value in the field product ID is nul

    Assignments: Assignments, instead of returning a Boolean success or failure result, populate data value of any type to a field on which they are applied. Assignments can follow a validation or can be written stand alone. An example of assignment following a validation is

    For Example: IF (IS_NULL (City),u201DMumbaiu201D, City) checks for whether the field City is null or not, if the field City is null then it assigns value u201CMumbaiu201D to the field City.

    Hope this will clear your doubt.

    TNR,

    Saurabh...

    Edited by: Saurabh Kumar Sahu on Jun 10, 2008 2:09 PM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 10, 2008 at 12:35 PM

    Thank you all.

    Saurabh whatever u said I got it.I tried to do that also. But the city which are blank value mumbai is not assigning there.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Shalini,

      Also you need to run the Assignment created. Select the record(s) on which assignments is to be run right click select Assignments -> Assignment Name (created) and then check the response.

      Regards,

      Jitesh Talreja

  • avatar image
    Former Member
    Jun 10, 2008 at 12:27 PM

    Hi Shalini,

    Callable : When you declare or make an validation as callable then its availabe as an function inside the expression. I mean first you declare an validation as callable, now create another validation and go to the last drop down where you can find the default functions, under that you will find ur validations also. By making an validation as callable you can make it as an user defined funciton.

    Branch : Suppose in your category(Taxonomy) table you have to childs (boys and girls) you have written an validation for boys and you want to append and validaton of girls to the same validation then you can make a branch of it and write the code for that in the branch validation, by default you will get the new branch validation in the boys validation with an AND inbetween..; another thing is that you cannot execute the baranch validation girl independtly, you can run your main validation boys with the interjunction.

    Assignment: Assignment is used to assign an value for any normal field in the table. when you run an validation you will get an boolean value either true or false stating wether your records are valid or not. But using assignments can be used to assign some values to a field depending upon some logic...

    Regards,

    Cherry.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 12, 2008 at 11:14 AM

    Hi Jitesh and Saurabh

    Yes your reply solved my problem. Many Many thanks.

    Add comment
    10|10000 characters needed characters exceeded