Data Summary and then some

Question

Hi,

how can I get from Input to Output data:

Input

Employee     Code

1                   22

2                    9

1                 113

3                  22

4                   9

3                113

Output

Employee  Code9   Code22   Code113

1                No          Yes          Yes

2               Yes         No            No

3               No           Yes          Yes

4               Yes

Creating the new fields (i.e. Code9, Code22, Code113) is not terribly difficult. I`m more struggling with how to fill them in correctly.

Thanks for any hints you folks can offer,

Joanna

Claje · Accepted Answer

Hi,

Here's a quick screenshot that might help:

Roughly, I used the Transpose tool with Employee as a Key Value, so that I got a series of Name/Value Columns.

I used the Select Tool to increase the width of the Name field, then the formula tool to add the code number to each column name.

Next, I used the Cross Tab tool, grouped by Employee, with the "Name" column for Headers, and "Value" for Values.

Lastly, I used the Multi-Field Formula tool.

Here's a snapshot of my configuration for that tool:

The key pieces here were deselecting "Employee" from my list of fields this would apply to, and changing the Output type to a String field so that we could capture Yes/No Values.