Forum Discussion
Looking Up Value from Another Table and Searching Column
Hello, I'm trying get a column to search for a specific value in another table and if it finds that matching value, it will take the value in a specific column and apply it to the new column. I b...
Greg_Deckler
Community Champion
Community Champion
I'm curently using LOOKUPVALUE and I get the error message "LookUpValue does not support comparing values of type integer with values of type text".Does that mean one of my columns that I picked is not the same as the other formats? I've tired using the expression FORMAT on that numeric column but I don't know what to put for the second condition if that makes sense.
FORMAT(Value,Format) I don't know what to put in format.
emadrigalHelper II
why dont you create a copy of that column with the same datatype create the relation and then hide it?
- Greg_Deckler
You could use VALUE to convert from text to numeric, would have to see the data to see what is going wrong there.