This is my initial data:
Name,Value
sza034,ber_afu
sza033,ber_awn
sza034,ber_afl
sza033,ber_afu
sza034,ber_afu
sza032,ber_awn
sza034,ber_afl
sza033,ber_fff
sza033,ber_bgt
sza033,ber_afu
sza033,ber_jij
The result has to be a matrix, with a row for each unique name and a column for each unique value.
the fields in the matrix have to be filled with "yes" or "no":
Name,gschber_afl,gschber_afu,gschber_awn,gschber_fff,gschber_bgt,gschber_jij
sza034,yes,yes,no,no,no,no
sza033,no,yes,yes,yes,yes,yes
sza032,no,no,yes,no,no,no
By using the Aggregator, AttributeSplitter, ListDuplicateRemover and ListSorter, I managed to get for each name a list with its unique values. But how can I write this matrix now?
Thanks in advance.
Vera
