Forum Discussion
i_kafali
8 years agoHelper II
SELECTCOLUMNS does not return correct values from existing table
Hello, I have an existing table called OK_INVOICE_ALL_EXCEL. so i have created new table called PARETO to make more lean table. To create PARETO table i used below formula PARETO = SELECT...
i_kafali
8 years agoHelper II
Yes distinct counts are also same for entity names
tex628
8 years agoCommunity Champion
Whats that value for the product ID column?
- i_kafali8 years agoHelper II
Both same Rex
- tex6288 years agoCommunity Champion
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! :)
- tex6288 years agoCommunity Champion
How is it going?