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 basically have a table with data that is mixed up together based on the 'Work Item Type' so I duplicated the table and filtered the other table to only show a specific 'Work Item Type'. The duplicated table is linked by a releated Work ID to the first table. I'm pulling data from VSTS if that helps.
8 Replies
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.
why dont you create a copy of that column with the same datatype create the relation and then hide it?
Hi SopandaT,
Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.
Best Regards!
Dalethe problem I had with LOOKUPVALUE function is that I could not reference to a column in a table under search value. I wanted to look up the same value in another table in one column and return the result of another column in that another table. Not sure how I could do it.
jennympho- Can you explain that again with maybe an example?
