keep both join attributes problem

New Altair Community Member
Updated by Jocelyn
Hello guys, i hope you can help me, i am really struggling with this problem
Follwing two simple csv files
File a:
id;label;cont1
0; ; a
1; 1b; b
2; 2c; c
File b:
id;label;cont2
0; 0x; x
1; 1b; y
2; ; z
the desired result:
id;label;cont1;cont2
0; 0x; a; x
1; 1b; b; y
2; 2c; c; z
Thought way to do: outer join with "keep both join attributes" and no "remove double attributes"
But unfortunately i am getting always the same result, no matter the option "remove double attributes" is on or off:
id;label;cont1;cont2
0; ?; a; x
1; 1b; b; y
2; 2c; c; z
Anyone has an idea what i am doing wrong? Tanks!