keep both join attributes problem

User: "johannesjungblu"
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!

Find more posts tagged with