Six Stars

Error: Incompatible operand types Float and String

Hi, 

I'm trying to load one of the dimension table into my DW, but it's throwing this error:

Detail Message: Incompatible operand types Float and String

 

On my datasource table I have 3 income fields (all Floats), and in my DW all 3 are also float. So I don't get it why it's saying string and float.

 

Any idea of what might be? Thanks!

 

1 REPLY
Nine Stars

Re: Error: Incompatible operand types Float and String

Check

1 - if the output table existed and stil has its old structure (create table if not exist)

2 - A variable you read is float but a function returns a string, most likely if you use a tMap to do stuff.

3 - You have == (equality test) when you want = (assignment).