Concatenate not working

This morning I tried to concatenate two files (of doubles) but the resulting output has ‘?’ instead of doubles for the second file. Is there a new bug?

Hey there,

Can you maybe share a little more information?

In general the answer is: No - to the best of my knowledge there’s no bug :-).

Do you first read in both files separately (e.g. 2 Excel reader nodes) and then concatenate? Do both tables, before you concatenate, have exactly the same column names and data types?

Hi Martin,
Its most odd. I have a large file which I am splitting out the first few metadata columns (manually or wildcard - make no difference) then I am taking the remaining columns of doubles which have two types of columns prefixed with “Raw” and “Normalised”. I’m using a column filter with a wildcard to only select “Normalised” columns. Then I am stitching them back together with Concatenate (Metadata first) but when I look at the combined result the numerical columns are all ‘?’. This is exactly the same as I have been using in the past but today it is not working…

@Mark_Earll you could use a

and make sure they have the same types and structure

Hello.
It’s hard to identify something without more data.
It seems like there’s something wrong with the data type.
Can you show a little bit of a view of the data?
Br

1 Like

DOH Sorry I meant to use JOIN. Not working on all 4 cylinders this morning . PLEASE DELETE TOPIC (Embarrassing!) Sorry to have bothered you

3 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.