DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
brendomac



Group memberships:
Premium Members

Joined: 29 Nov 2016
Posts: 6
Location: australia
Points: 49

Post Posted: Thu May 25, 2017 5:18 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Server
OS: Windows
Hi,

I am learning the ins and outs of rule designer. I am looking at using the inbuilt name rule (AUNAME) to investigate to different files, both with different structures for a name field.

I am doing this through the standardise function, then the AUNAME ruleset.

My question is: Since the format of the name is different in each file and I want to add an override that applies to each individually but not both, do I need to create a copy of the AUNAME set, or can I restrict what override applies to each file so that I do not need to make a copy of the ruleset?

For example:
File A has Firstname Middle Name. e.g Mary Sally (FF) I override this so it goes to first name then middlename
File B has Firstname Alias. e.g John George (FF) I would want this to go to first name then alias.

So both have two firstnames, both need overrides, the override pattern is the same (FF), but the output is different.


Many thanks
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42576
Location: Denver, CO
Points: 219102

Post Posted: Thu May 25, 2017 6:57 pm Reply with quote    Back to top    

This sounds like a QualityStage question... yes?

_________________
-craig

I know I don't say this enough, but I like when you talk to me. It's much better than when nobody talks to me. Or when people that I don't like will not stop talking to me.
Rate this response:  
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54221
Location: Sydney, Australia
Points: 294071

Post Posted: Thu May 25, 2017 7:48 pm Reply with quote    Back to top    

Yes. Please move it.

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
brendomac



Group memberships:
Premium Members

Joined: 29 Nov 2016
Posts: 6
Location: australia
Points: 49

Post Posted: Thu May 25, 2017 8:43 pm Reply with quote    Back to top    

Is moving the post something I can do, or do you mean that the admins move it? Thanks.
Rate this response:  
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42576
Location: Denver, CO
Points: 219102

Post Posted: Thu May 25, 2017 8:43 pm Reply with quote    Back to top    

Done.

_________________
-craig

I know I don't say this enough, but I like when you talk to me. It's much better than when nobody talks to me. Or when people that I don't like will not stop talking to me.
Rate this response:  
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42576
Location: Denver, CO
Points: 219102

Post Posted: Tue May 30, 2017 7:29 am Reply with quote    Back to top    

Now hopefully someone can answer your question...

_________________
-craig

I know I don't say this enough, but I like when you talk to me. It's much better than when nobody talks to me. Or when people that I don't like will not stop talking to me.
Rate this response:  
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54221
Location: Sydney, Australia
Points: 294071

Post Posted: Tue May 30, 2017 5:25 pm Reply with quote    Back to top    

Best practice for copying a Rule Set is to use the Designer client. Right click on AUNAME.SET and choose Create a Copy. This will create copies of all the objects in AUNAME rule set. You can re ...

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42576
Location: Denver, CO
Points: 219102

Post Posted: Wed May 31, 2017 6:59 am Reply with quote    Back to top    

So... that addresses the subject of the question but not the substance of it. Hopefully more help will be coming. Wink

_________________
-craig

I know I don't say this enough, but I like when you talk to me. It's much better than when nobody talks to me. Or when people that I don't like will not stop talking to me.
Rate this response:  
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54221
Location: Sydney, Australia
Points: 294071

Post Posted: Wed May 31, 2017 5:14 pm Reply with quote    Back to top    

If the number of exceptions is small, you could use an input text override. Otherwise the only way to make new conditional pattern-actions is to edit the pattern action language for the rule se ...

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours