Toad World® Forums

MOE - Uncheck Columns with matching data


#1

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. :slight_smile:

Blessings,

Phyllis


Phyllis Helton

Data Magician

Digital Products & Strategies, Cru | Data Sciences & Analytics
Office :phone: 407-515-4452
phyllis.helton@cru.org


#2

It’s working for me, Phyllis. Can you give me a “select stuff from dual union select more stuff from dual” to reproduce it?


#3

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 :phone: 407-515-4452

phyllis.helton@cru.org


#4

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 :phone: 407-515-4452

phyllis.helton@cru.org


Phyllis Helton

Data Magician

Digital Products & Strategies, Cru | Data Sciences & Analytics
Office :phone: 407-515-4452

phyllis.helton@cru.org


#5

Sadly, when I recreate it from dual, the columns hide properly. :frowning: 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 :phone: 407-515-4452

phyllis.helton@cru.org


Phyllis Helton

Data Magician

Digital Products & Strategies, Cru | Data Sciences & Analytics
Office :phone: 407-515-4452

phyllis.helton@cru.org


Phyllis Helton

Data Magician

Digital Products & Strategies, Cru | Data Sciences & Analytics
Office :phone: 407-515-4452

phyllis.helton@cru.org


#6

OK. I hope you used the Export Dataset option to make your DUAL statement rather than type all that manually! :slight_smile:


#7

Of course! :slight_smile:

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! :slight_smile:

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 :phone: 407-515-4452

phyllis.helton@cru.org