none
Term-Based Relations

    Frage

  • I'm setting upp a cleance project and have a domain that need to be cleanced from the sign -.  Is there any 'wild card' setting in the term-Based Relations?

    I have tried with all type setting ( % ! ...) but it don't work. 

    ex 12345-6774 should result in 123456774,  i have tried even with 5-6 correct to 56 but it did't work.

    Is there a solution to this?

    Donnerstag, 15. November 2012 14:24

Antworten

  • The matching can have optional characters

    like 1234[0]6789 will match on

    12346789 and 123456789

    or 1234-[0][0][0][0] will accept 1234- and 1234-1234
    Dienstag, 20. November 2012 15:47
  • Hi Monica,

    In order for the "-" TBR to work, the stripped value needs to already exist in the list of domain values.

    So, for example...

    Domain Values
    1234

    Source Values
    123-4
    67-89

    ...the "-" TBR will work for source value "123-4", but not for source value "67-89" because 6789 isn't in the list of domain values.  If you add 6789 to the domain values, the TBR should work.

    I realize this isn't the same as a wild-card.  You use-case may require preprocessing on source data to handle this.  Unfortunately, DQS is still a release-1 product :-/

    Donnerstag, 29. November 2012 15:16

Alle Antworten

  • I believe you can simply setup a TBR for "-" (single character, no quotes) and leave the "Correct To" field blank.  

    Then, from your example (ex 12345-6774 should result in 123456774), as long as 123456774 (no dash) is listed in the domain values for this particular domain, you should find that the TBR strips the "-" from 12345-6774

    Dienstag, 20. November 2012 13:05
  • The matching can have optional characters

    like 1234[0]6789 will match on

    12346789 and 123456789

    or 1234-[0][0][0][0] will accept 1234- and 1234-1234
    Dienstag, 20. November 2012 15:47
  • I believe you can simply setup a TBR for "-" (single character, no quotes) and leave the "Correct To" field blank.  


    That should work.

    Help Others! Don't forget to mark your thread as answered

    Rafael Salas - SSIS and more

    Mittwoch, 21. November 2012 00:47
  • It don't work with just - in the TBR, that's why I ask for wildcard sign.

    The optinal characters will not work since the sign - will be in any place within the data.

    Monica

    Donnerstag, 29. November 2012 14:58
  • Hi Monica,

    In order for the "-" TBR to work, the stripped value needs to already exist in the list of domain values.

    So, for example...

    Domain Values
    1234

    Source Values
    123-4
    67-89

    ...the "-" TBR will work for source value "123-4", but not for source value "67-89" because 6789 isn't in the list of domain values.  If you add 6789 to the domain values, the TBR should work.

    I realize this isn't the same as a wild-card.  You use-case may require preprocessing on source data to handle this.  Unfortunately, DQS is still a release-1 product :-/

    Donnerstag, 29. November 2012 15:16