Error in using join command

Question

0 个投票

Hello,

I have a problem about using join cmmand. I have two tables and I would like to join them, taking into consideration the first column (Var1). I use

C=join(A,B);

where A and B are tables, but command window shows me

Error using tabular/join (line 130)

Left and right key variables 'Var1' and 'Var1' are not comparable because one is a non-cell.

Could you please help me?

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

the cyclist 2022-12-28

编辑：the cyclist 2022-12-28

Can you upload the data (or a subset)? You can use the paper clip icon in the INSERT section of the toolbar.

The error message is fairly clear. If the two columns are not the same data type, you presumably need to convert one of them, to do the join.

Answer 1

Kunal Kandhari 2023-1-17

0 个投票

Hi,

From the error messgae it seems like two columns doesn't have the same data type and you need to convert one of them.

Following resources would be helpful to you: