Forum Discussion
SELECTCOLUMNS does not return correct values from existing table
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) :)
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?