I haven’t had to do data research for a while, so I can’t tell you how long this hasn’t been working, but it is NOT a problem in the GA version.
I just now ran a query in the editor that returned duplicate data in a table with 251 columns (in case that is relevant). The query returns all the columns. When I select the first two records on the data grid, left click on the column selector and then right-click to select “Uncheck columns with matching data”, most of the duplicate columns disappear, but there are a few that remain.
Some have nulls in them and some have text values that come from pick lists, so I know they really truly are the same with no hidden spaces or special characters. Most of the columns that remained that should have been unchecked are at the beginning of the table, but I can’t see any pattern about why they would have remained checked.
Fortunately, it removed enough columns that I was able to find the problem, but it would be super nice if we could have that option hide all the columns with duplicate data. 
Blessings,
Phyllis
–
Phyllis Helton
Data Magician
Digital Products & Strategies, Cru | Data Sciences & Analytics
Office 
407-515-4452
phyllis.helton@cru.org
It’s working for me, Phyllis. Can you give me a “select stuff from dual union select more stuff from dual” to reproduce it?
SELECT *
FROM siebel.w_product_d
WHERE 1 = 1
AND part_num IN (SELECT part_num
FROM siebel.w_product_d pr
WHERE 1 = 1
AND PR.PRODUCT_TYPE_CODE = 'Designation'
AND PROD_NAME IS NOT NULL
AND pr.status = 'Active'
HAVING COUNT(1) > 1
GROUP BY part_num)
ORDER BY part_num
On Wed, Jun 6, 2018 at 2:18 PM, John Dorlon bounce-jdorlon@toadworld.com wrote:
RE: MOE - Uncheck Columns with matching data
Reply by John Dorlon
It's working for me, Phyllis. Can you give me a "select stuff from dual union select more stuff from dual" to reproduce it?
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle - Beta Forum notifications altogether.
Toad for Oracle - Beta Discussion Forum
Flag this post as spam/abuse.
--
Phyllis Helton
Data Magician
Digital Products & Strategies, Cru | Data Sciences & Analytics
Office 
407-515-4452
phyllis.helton@cru.org
Sorry just read your request more closely. I'll re-write it from dual.
On Wed, Jun 6, 2018 at 2:42 PM, Phyllis Helton phyllis.helton@cru.org wrote:
SELECT *
FROM siebel.w_product_d
WHERE 1 = 1
AND part_num IN (SELECT part_num
FROM siebel.w_product_d pr
WHERE 1 = 1
AND PR.PRODUCT_TYPE_CODE = 'Designation'
AND PROD_NAME IS NOT NULL
AND pr.status = 'Active'
HAVING COUNT(1) > 1
GROUP BY part_num)
ORDER BY part_num
On Wed, Jun 6, 2018 at 2:18 PM, John Dorlon bounce-jdorlon@toadworld.com wrote:
RE: MOE - Uncheck Columns with matching data
Reply by John Dorlon
It's working for me, Phyllis. Can you give me a "select stuff from dual union select more stuff from dual" to reproduce it?
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle - Beta Forum notifications altogether.
Toad for Oracle - Beta Discussion Forum
Flag this post as spam/abuse.
--
Phyllis Helton
Data Magician
Digital Products & Strategies, Cru | Data Sciences & Analytics
Office 407-515-4452
phyllis.helton@cru.org
--
Phyllis Helton
Data Magician
Digital Products & Strategies, Cru | Data Sciences & Analytics
Office 407-515-4452
phyllis.helton@cru.org
Sadly, when I recreate it from dual, the columns hide properly. 
Even when I select values for all 251 columns!
Maybe we'll just chalk this one up to being an anomaly. If it happens again, I'll work on trying to duplicate it from dual again.
On Wed, Jun 6, 2018 at 2:42 PM, Phyllis Helton phyllis.helton@cru.org wrote:
Sorry just read your request more closely. I'll re-write it from dual.
On Wed, Jun 6, 2018 at 2:42 PM, Phyllis Helton phyllis.helton@cru.org wrote:
SELECT *
FROM siebel.w_product_d
WHERE 1 = 1
AND part_num IN (SELECT part_num
FROM siebel.w_product_d pr
WHERE 1 = 1
AND PR.PRODUCT_TYPE_CODE = 'Designation'
AND PROD_NAME IS NOT NULL
AND pr.status = 'Active'
HAVING COUNT(1) > 1
GROUP BY part_num)
ORDER BY part_num
On Wed, Jun 6, 2018 at 2:18 PM, John Dorlon bounce-jdorlon@toadworld.com wrote:
RE: MOE - Uncheck Columns with matching data
Reply by John Dorlon
It's working for me, Phyllis. Can you give me a "select stuff from dual union select more stuff from dual" to reproduce it?
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle - Beta Forum notifications altogether.
Toad for Oracle - Beta Discussion Forum
Flag this post as spam/abuse.
--
Phyllis Helton
Data Magician
Digital Products & Strategies, Cru | Data Sciences & Analytics
Office 407-515-4452
phyllis.helton@cru.org
--
Phyllis Helton
Data Magician
Digital Products & Strategies, Cru | Data Sciences & Analytics
Office 407-515-4452
phyllis.helton@cru.org
--
Phyllis Helton
Data Magician
Digital Products & Strategies, Cru | Data Sciences & Analytics
Office 407-515-4452
phyllis.helton@cru.org
OK. I hope you used the Export Dataset option to make your DUAL statement rather than type all that manually!
Of course! 
On Wed, Jun 6, 2018 at 3:14 PM, John Dorlon bounce-jdorlon@toadworld.com wrote:
RE: MOE - Uncheck Columns with matching data
Reply by John Dorlon
OK. I hope you used the Export Dataset option to make your DUAL statement rather than type all that manually!
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle - Beta Forum notifications altogether.
Toad for Oracle - Beta Discussion Forum
Flag this post as spam/abuse.
--
Phyllis Helton
Data Magician
Digital Products & Strategies, Cru | Data Sciences & Analytics
Office 407-515-4452
phyllis.helton@cru.org
407-515-4452