Can you link two data sets with a formula?

[PaulW]

I have two data sets which I need to link.

The 1st data set contains a column of unique entries where each entry might have similar initial key words, however the last portion of each entry has a unique code (i.e. Group0001, Group0002, etc...).

I would like to link this to a 2nd data set which would classify for argument sake all entries starting with Group, as part of a specific category, eg. Assembly.

Can I link these two data sets by using a formula that will search for key phrases in the 1st data set and link it to the 2nd data set?

[dplr-rn]

share some sample data please.

[PaulW]

Hi,

See attached example.

DataSet2 contains a partial match, which if found in DataSet1, should be linked to a specific category. 

[marcus_malinow · Accepted solution]

Ok, it looks like you can link part of your description field to your PartialMatch field.

You'll need to derive a new field when loading your DataSet1 table

SubField(Description, '_', 1) as PartialMatch

This will then associate to the PartialMatch field in your DataSet2 table

[dplr-rn · Accepted solution]

create new column in DataSet1 like so

subfield(Description,'_',1) as PartialMatch