I have generated a SQL table in my procedures. When I try to right-click the table and then 'Data Profiling' and then click 'Statistics', it is giving me the following error: (FOC1071) VALUE FOR JOIN 'TO' FIELD OUT OF SEQUENCE. RETRIEVAL ENDED
I have no problem opening the table and it gives me data. I can also do the 'Count' function or 'Key Analysis'.
What can I try to make 'Statistics' work again?
Thank you for your suggestions.This message has been edited. Last edited by: Tamra,
Windows 7, All Outputs
Member of the Benelux Usergroup
Does Data Profiling work for some tables and not others? If so please open a hottrack case and upload the synonym for the table that is problematic.
Your signature shows WebFOCUS 7703. If you are still running that release (which first came out in 2011) you may want to consider upgrading to the current production release. Data Profiling has been much enhanced since then.
Have you ensured that the second table of the JOIN, the 'TO' table, has been ordered by the key by which you are joining the tables together?
Windows, All Outputs
|Powered by Social Strata|