Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello!
I am going mad here. Data set contains collection address and delivery address on the same line. Countries are coded by name and I have successfully created a Collection Country Name column using LOOKUPVALUE, but when following the same process for the Delivery Country I am getting the following error: lookupvalue does not support comparing values of type integer with values of type text. consider using the VALUE or FORMAT function to convert one of the values
Attached a screenshot to demonstrate.
Formula used for Collection Country:
Solved! Go to Solution.
It looks like the data type of Delivery Country ID column is Text. Change that to Number from your Query editor..
I was looking at the wrong column.
You have fixed it - thank you so, so much!!
Thank you for the quick response. I have triple checked and the text columns are text columns, the numerical ones are numbers.
I am stumped!
The Delivery Country ID values are aligned to Left and this happens when the data type of that column in not a Number. Whereas the Collection Country ID numbers are alighed to right which is the case when the data type is Number.
It looks like the data type of Delivery Country ID column is Text. Change that to Number from your Query editor..
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |