Query.jl join error - DataValues.DataValue{String} vs String


#1

I got this error when using Query.jl to join two tables, where one table was read from CSV.jl and the other from ExcelReaders.jl.

I guess I could convert the columns somehow but wondering if there’s a better way to handle that… thanks in advance.

The keys in the join clause have different types, 
DataValues.DataValue{String} and String.

#2

I worked around by “promoting” the value to DataValue type in the join condition.


#3

Yeah, that is the best option right now. I’m enforcing that the values one joins on have to be of the same type right now. I might relax that at some point, but I need to think about it a bit more :slight_smile: