Forum Discussion
SELECTCOLUMNS does not return correct values from existing table
Quick question, if you compare your PARETO table to your original table, does the row count differentiate?
Rex, both has 970.250 rows
I understand, i'm in the same spot.
I have an idea that might be the cause.
My thought is that the entities that show correct values are distinct, while those that show inconsistant values occur in more than one row.-----
Either way, this is a rather difficult issue. is it possible for you to create a relationship between INVOICE and PARETO?
To create a relationship one table must have unique values in all 970,000 rows.
Do you have any column that has all unique values? Proberbly something like ProductID or something similar?
Rex i also tried that (product id, customer id etc.) still didnt work.
Also i produced all the columns in PARETO table from OK_INVOICE_EXCEL table. shouldnt it be unique since row counts are the same?
I really don't understand :(
If you take a look at your column like this:
You can see that my Questions column has 12 unique rows while my Answers column only has 3!
See if you have any where all 970,000 rows are unique (distict) :)I'm trying out some stuff right now. Is ur data confidential or can you send the file?
Next question!
In this picture:
Is the OK_INVOICE_EXCEL Values from a measure while PARETO values are from a column?
rex its highly confidential im sorry and its about 210mb
volume ton is calculated measure from OK_INVOICE_EXCEL which i try to use in PARETO table with SELECTCOLUMN formula
Rex i tried to create relationship between those two tables but then it says like in the picture
Yes distinct counts are also same for entity names
Whats that value for the product ID column?
Both same Rex
Alright, I think you will need to create a key for the relationship then.
This is done by concatinating several columns into one. Like this:
New column = [ProductID] + [Month] + [City] + [SalesID]
You have to find columns yourself and the aim is to have 970250 distinct rows!
Like that ^
/ Might might not be able to respond any more today but I'll continue tomorrow in that case! :)
How is it going?