Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2 . Extracting Information - Dealing with blank ghost columns Often when importing data from Excel sheets, we have to deal with additional 'ghost' columns

2. Extracting Information - Dealing with blank ghost columns
Often when importing data from Excel sheets, we have to deal with additional 'ghost' columns that appear to be completely blank.
How would you deal with ghost columns in an Excel file, in particular, if you did not know how many of these additional blank columns were going to be present each time the query is refreshed?
a. Removing the column count from the file reference eg."Columns=19"
b. Use the "Remove Other Columns" instead of "Remove Columns"
c. Use the column header to filter out blank values

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Spatial Databases With Application To GIS

Authors: Philippe Rigaux, Michel Scholl, Agnès Voisard

1st Edition

1558605886, 978-1558605886

More Books

Students also viewed these Databases questions

Question

3. Which of the means is useful for comparing rates?

Answered: 1 week ago

Question

1 Why is job analysis important?

Answered: 1 week ago