Hello everyone,
I have the following data structure and I don’t know which solution would be the best in FME Form to get the required result:
attribute1; attribute2; attribute3
Kreuzberg; Rom; group 1
Berlin; Kreuzberg; group 1
England; London; group 4
London; England; group 4
Lissabon; Carrer; group 2
Carrer; Lissabon; group 1
Kreuzberg1; Rom; group 1
Rom; Kreuzberg2; group 1
I need to create a group_id attribute that has the same id where attribute1 values reappear in attribute 2 and vice versa + the features need to have the same attribute3 to get the same group_id. This is how the output should look like:
attribute1; attribute2; attribute3;group_id
Kreuzberg; Rom; group 1;1
Berlin; Kreuzberg; group 1;1
England; London; group 4;2
London; England; group 4;2
Lissabon; Carrer; group 2;3
Carrer; Lissabon; group 1;4
Kreuzberg1; Rom; group 1;5
Rom; Kreuzberg2; group 1;5
Thanks for helping!