SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

matching variables in dataflux

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 17
Accepted Solution

matching variables in dataflux

Hello All,

 

I have Dataflux Management Studio 2.4.

 

Is it possible to create a match between full names and initials? I mean, may I create a match between "First Investment Date" and "FID"?

 

Thank you for your time and help.

 

Best,

Margherita

 


Accepted Solutions
Solution
‎08-22-2016 03:08 AM
SAS Super FREQ
Posts: 90

Re: matching variables in dataflux

Yes, that's it. Use Customize to open the Quality Knowledge Base (QKB) and navigate to the match definition you want to use. Once you open the match definition, you can see the various files that it employs to match data. The product documentation describes how to use the Customize application. Consider making a copy of the match definition first using Customize before you start making changes.

 

Ron

View solution in original post


All Replies
SAS Super FREQ
Posts: 90

Re: matching variables in dataflux

Hi Margherita,

 

Yes, you can do this in DataFlux Data Management Studio 2.4. First you should identify the match definition you want to use, probably the "Organization" match definition for the locale/language of the data you want to match. Then use the Customize component to open the match definition so you can see the different steps of the algorithm. One of these steps will be a standardization step where data is transformed to find matches like you describe. Find the appropriate standardization definition (most organization match definitions will have a standardization "scheme" with a few of these kinds of transformations already), open it and add the variations you would like to have match. Save the scheme changes. If you had a job open while you were making these changes, close it and reopen it to reload the Quality Knowledge Base that contains the updated definiton.

 

Ron

Occasional Contributor
Posts: 17

Re: matching variables in dataflux

 

Hello Ron,

 

thank you for your reply.

 

I am a dummy in DataFlux Smiley Happy so... is this the Customize component ?

cust.png

If not, where is the Customize component to open and modify the match definition?

 

Thank you again and I am sorry for the trivial question.

 

Best,

Margherita

 

Solution
‎08-22-2016 03:08 AM
SAS Super FREQ
Posts: 90

Re: matching variables in dataflux

Yes, that's it. Use Customize to open the Quality Knowledge Base (QKB) and navigate to the match definition you want to use. Once you open the match definition, you can see the various files that it employs to match data. The product documentation describes how to use the Customize application. Consider making a copy of the match definition first using Customize before you start making changes.

 

Ron

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 314 views
  • 2 likes
  • 2 in conversation