I am trying to standardize multiple date columns (and other multiple columns) from custom rules sets. When I try to add 5 vDate standizations (one for each date), I get an error that says "Cannot add the same process twice". When adding all the dates into the vDate rule set, i only get one set of standardization outputs.
Is there a way I can apply a rule set to multiple columns (meaning to check each column) without adding five standization components in my case back to back?
Standardize multiple date columns
Standardize multiple date columns
Don
DataStage Developer
DataStage Developer
Each rule set can only be used once in a STN stage. This is because the output column is formed based on the rule set name. If you were able to use the same rule set more than once, you would get the duplicate column names, and that is not allowed in DataStage/QualityStage.
You can copy VDATE four times (VDATE2, VDATE3, etc), and then use those rule sets in one STN job.
You can also copy and modify VDATE to accept five date columns, but what would require Pattern Action Language knowledge. You might be better off with the first option :D
You can copy VDATE four times (VDATE2, VDATE3, etc), and then use those rule sets in one STN job.
You can also copy and modify VDATE to accept five date columns, but what would require Pattern Action Language knowledge. You might be better off with the first option :D
Regards,
Robert
Robert
Each rule set can only be used once in a STN stage. This is because the output column is formed based on the rule set name. If you were able to use the same rule set more than once, you would get the duplicate column names, and that is not allowed in DataStage/QualityStage.
You can copy VDATE four times (VDATE2, VDATE3, etc), and then use those rule sets in one STN job.
You can also copy and modify VDATE to accept five date columns, but what would require Pattern Action Language knowledge. You might be better off with the first option :D
You can copy VDATE four times (VDATE2, VDATE3, etc), and then use those rule sets in one STN job.
You can also copy and modify VDATE to accept five date columns, but what would require Pattern Action Language knowledge. You might be better off with the first option :D
Regards,
Robert
Robert
Yes, I was thinking about just duplicating the rule sets too. Only problem is then if you have to update it, then you have to update them all.rjdickson wrote:Each rule set can only be used once in a STN stage. This is because the output column is formed based on the rule set name. If you were able to use the same rule set more than once, you would get the duplicate column names, and that is not allowed in DataStage/QualityStage.
You can copy VDATE four times (VDATE2, VDATE3, etc), and then use those rule sets in one STN job.
You can also copy and modify VDATE to accept five date columns, but what would require Pattern Action Language knowledge. You might be better off with the first option :D
You'd think IBM could just append a number to the end of the name and use a loop to support this feature. Maybe the next release.
That is a good idea to modify vDate, but I'd still have to update however many dates I allowed if something changed. I had to modify vDate anyway, since it doesn't accept the CCYYMMDD date format as input even though it outputs only that format.
I think I'm going to go with copying the rule set. Thanks for the help.
Don
DataStage Developer
DataStage Developer
-
- Participant
- Posts: 527
- Joined: Thu Apr 19, 2007 1:25 am
- Location: Melbourne