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
Solved! Go to 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.
Thank you Claje!
Works very well indeed!