Find columns similar to test column (one by many correlation)With 20,000 columns of continuous data, correlation of all by all is undesirable. How to calculate correlation of all columns vs one column (many to one)? to find similar columns.
AnalyticsRe: Find columns similar to test column (one by many correlation)You can get what you need by using Response Screening
Analyze=>Screening=>Response Screening
Place your 20,000 rows in the Y Response and your single comparison column in the X
