DSXchange

REM 'This function takes in a material number as a parameter and parses the package size out of the material number' REM 'The following are some of the varaibles that will be used in the logic' Numeric = "0123456789,." Alpha = "ABCDEFGHIJKLMNOPQRSTUVWXYZ" NextDash = 0 AfterDashS...

Dear all I have a few server routines that takes in a variable and parses it out. In short we have a lot of information in our material number and I have to parse out components based on some specific logic. The logic is working great and it returns and tests out great. I just have one concern.. as ...

Dear all I am trying to use qualitystage to find matches within our customer master The challenge I have is I do not have a whole lot of input to go off. All I have is a file with two columns customer name and state For this post please assume data is specific to US only. I have not used standardiza...

ray.wurlod wrote:Do you have the "return multiple rows from reference link" option selected?

Option "return multiple rows" helped! Thank you very much!!! :D

I have a problem using range option in the Lookup stage. I need to perform Lookup for the combination of 2 fields: Field1 Comp_Code - one to one lookup Field2 ACCT - range lookup (=>ACCT_from, =<ACCT_to) The stage does not let me to include ACCT_from and ACCT_to to the key. Here is the situation tha...

Is the project where you are building a job an existing project where you just started building QS jobs

or

Just curious if this is a new project that you are running this job in and if you by any change copied the DSParams file to get your environment varaibles for the job....

Can one actually modify the MNS ruleset without losing IBM support

Hi we are using MNS to standardize the country, province and postal codes... IN using MNS where we feed the address fields from input for it to process the output, we find that for POSTAL CODES for countries canada and uk which are alpha numeric in nature of lenght 7 with a space after the 3rd chara...

Hi I am trying to intepret the survivor ship rules, and we have a need where our rule say for a given field... "Keep survivor info if present otherwise populate Victim or loser Info" I am trying to figure out how this is best done in QS I think I can use Longest as essentially I think it w...

Hi All I am processing a set of flat files of data and I am standardizing using USNAME ruleset I was getting this warning on all the columns generated from the standardization stage when it is used in the next transformer. By default it generates columns of type VARCHAR. My unicode or extended prope...

Hi Great.. as I renamed it to SCNAME to be consistent with NAME being in the end and it seemd to work great job.... I will try to see what happens lenght of the ruleset name Just curious if this is document anywhere as I tried to find it on the IBM site just did not find anything or may be I am look...

Thanks Ray, will mark it as complete but I have one more question before I mark it complete I copied the GBNAME rule set and gave it a custom name as in GBNAME_cp_test Did not change any other aspect of the ruleset and when I use it I do get the optional name handling options enabled for me But when...

Yes it helped

I copied a USNAME rule set and tried it and sure enough worked

We can mark this as closed

Hi
When I copy the usaddr ruleset and just use it as is without customizing it, I see that the optional names handling is disabled

I changed the permission of the files under the quality folder to match the USADDR files

Any reasons why it is disabled.

Has anyone run into this before

Thanks for the reply. What we are after is address standardization only. Not postal code verification. In that case, just curious if we can just use MNS stage. Just curious what are some of the pain points of using MNS stage In searching through I did not get a lot of hits on MNS stage so just curio...