How to merge unique values from multiple fields into one field

Hello Experts,

Just wondering if anyone is kind enough to provide some clues or hints on how to solve this simple yet tricky data manipulation. question.

I'd like to merge multiple fields as shown below into one column while keeping the unique values and its relationship intact. Would it be possible?

Occupation > Gender > Year Joined > Age

[Before]

[Intended Result]

Is there any quick way to do this? perhaps I am missing out some tools that can perform such task.

Any clue or tips would be greatly appreciated.

Workflow

Preparation

Accepted answers

Qiu

@owenkosnen
Promise me you will not change the schema of input data, and this should work.

1208-owenkosnen-1.yxmd

All comments

Qiu

@owenkosnen
Hope this is what you need.

1208-owenkosnen.yxmd

Emil_Kos

Hi @owenkosnen,

It took me some time to understand what is the goal of the exercise and I think @Qiu created elegant solution for you. I have a quick question as I am curious about it why do you need a data in this format?

Qiu

@Emil_Kos
Thank you so much for your comment😁

owenkosnen

Hi @Qiu , Thanks for your solution, really appreciate your effort to help me out with this!

Just a quick question - it seems that the Unique Tool is not quite the right tool to use as it is deleting the duplicates even though they are actually not duplicates. For example: Teacher has 2 different 'Year Joined' but contain same age. One of the age is deleted by Unique Tool. I am having this problem hence not I am looking for other solution.

[Unique Tool] [Intended Result]

Teacher Teacher

2010 2010

40 40

2011 2011

@Emil_Kos - The list will be used as an input source to generate Tree UI using the Tree Interface Tool. I already have a workflow to assign reference key, all I need is to solve this puzzle.. Kudos to @Qiu !

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335