Data Summary and then some

[joannatg]

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 solution]

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.

[joannatg]

Thank you Claje!

Works very well indeed!