Assign and combine operation in unique id

[Former Member]

Hi all,

   Performed cleansing and matching for Table-1 and generated unique id using assign operation.

   Next day Table-2 is passed, matched records in Table-1 and Table-2 will get same unique id and unique records will get new unique id.

   Is assign combine operation will suit this requirement???

   If it suits, how to pass Table-2 to match records from Table-1 any transforms I have to use to compare Table-1 and Table-2.

Thank you.

[former_member187605 · Accepted solution]

Check out the Table_Comparison and Key_Generation transforms.

[virginia_hagen]

The Assign option:  "Assigns a new ID to unique records that need one, or assigns a new ID to all members of a group that don't have an ID.  In addition, the assign operation copies and existing ID when a member of a match group already has an ID..."  

The documentation does contain more detail on all of the options available using the Unique ID functionality of the Match transform and the options that you have as far as how the ID is assigned. 

The starting number for the Unique id is based on how you configure the transform.  If you are using the table1 as part of match, the unique id can keep the number assigned.  Otherwise it will start numbering them based on the option used.   The transform is configurable to meet your needs.  Please refer to the designer guide or the content sensitive help in the match transform for additional information on all the options you have for creating a Unique ID.