Hi, I'm looking to concat the contect of 2 cells based on the unique identifier to create a new field without changing the structure of the data&colon; Input: IDTypeName1Enablerapples 2Dependentwine1Dependentjuice3Dependentchips3Enablerpotatoes2Enablergrapes Desired output: IDTypeNameConcatenated field1Enablerapple apple juice 2Dependentwinegrape wine1Dependentjuiceapple juice3Dependentchipspotato chips3Enablerpotatopotato chips2Enablergrapegrape wine Thanks

Concate fields with unique identifier

Hi,

I'm looking to concat the contect of 2 cells based on the unique identifier to create a new field without changing the structure of the data&colon;

Input:

ID	Type	Name
1	Enabler	apples
2	Dependent	wine
1	Dependent	juice
3	Dependent	chips
3	Enabler	potatoes
2	Enabler	grapes

Desired output:

ID	Type	Name	Concatenated field
1	Enabler	apple	apple juice
2	Dependent	wine	grape wine
1	Dependent	juice	apple juice
3	Dependent	chips	potato chips
3	Enabler	potato	potato chips
2	Enabler	grape	grape wine

Thanks

Preparation

Accepted answers

MarqueeCrew

It is morning and a module is here now. It is very close to the descriptions of a sleepy community member.

Concatenate Fields.yxmd

All comments

MarqueeCrew

The plurals in the examples are ignored.

Take your input and filter it on type == "Enabler"

Setup 2 join tools

1. True to left & false to right (from filter). Join key is ID.
2. true to right & false to left (from filter). Join key is ID.

3. Union both Join outputs (J) together.

4. Formula: concatenated field gets;

[name] + " " + [right_name]

5. Select to cleanup fields.

I think that this should get you where you are trying to go.

Thanks,

Mark

MarqueeCrew

You will need to have a formula after each join. You'll setup the concatenated field with the appropriate enabler and dependent field.

Then you can select, cleanup and union the data back together.

Minor revision.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335