Forum Discussion

i_kafali's avatar
i_kafali
Icon for Helper II rankHelper II
8 years ago

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...
Need Help
Show and Tell
Tips and Tricks
tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
8 years ago

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?

i_kafali's avatar
i_kafali
Icon for Helper II rankHelper II
8 years ago

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 :(