Skip to Content
avatar image
Former Member

Assign and combine operation in unique id

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Apr 07, 2016 at 09:01 AM

    Check out the Table_Comparison and Key_Generation transforms.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 12, 2016 at 01:39 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded