I am having an annoying problem trying to join columns with the joiner node
I have an output from a column filter with two columns of strings which have the row ID's as 1.0, 2.0, 3.0 etc Then I have the output from an R script (3 columns of doubles) with row ID's 1, 2, 3 etc I then try to join by RowID yet all I get is an empty table. I presume it refuses to join becaue one row ID is "1.0" and the other "1"
Why does the column filter and R node name the rows differently? Is there a workaround?
Replying to my own problem! I think the issue comes from the XLS Excel reader node where it has picked up my integer row index as a double, i.e 1.0 rather than 1. Even if you change the row index in excel to be "text" the XLS reader still reads it as "1.0". The only workaround I have found is to save the file as text and use the FileReader node instead of the XLS reader.
Hi Christian. I have two similar tables like example. "Number" is joining column but this column have different formats in different tables. When i use the double to int node then little values don't join. When i don't then big values don't join.
Really I found the decision already but I don't like it.
I used sequently two nodes: "number to string" and "string to number" for this column. Formats became same and now tables join correctly.