data dictionary for related code.

[MZ900605]

Hello guys I need a suggestion on how to do a code dictionary that is efficient.

my input looks like this:

name	Case	CODE
A	injury while fixing...	12233
B	Car gas ...	55666
A	new clothes	880099
A	injury while playing...	12233
C	injury while lifting ...	12233
D	new clothes	880099
B	Car gas for...	77543

I want to make a workflow that the Cases will be shortened to one or 2 words and when the same name has 2nd case add 2nd to the case.

and have a sample dictionary workflow to do this whenever I enter a table with these entries.

Name	Case	Code
A	Injury	12233
B	Car gas	55666
A	new clothes	880099
A	Injury 2nd	12233
C	Injury	12233
D	new clothes	880099
B	Car gas 2nd	55666

[Sebastiaandb]

Hi @MZ900605 ,

Here you go:

Let me know if this is what you're looking for :-). 

In your second table you have "Car gas 2nd", but in the first there's only one row with "Car gas" so that made me a bit insecure about my solution :-).

Greetings,

Seb

[MZ900605]

@Sebastiaandb  I'll edit the entry table now my mistake, thanks will try it

[MZ900605]

still cannot apply this the data is almost 1000 different codes with multiple cases.