Home › Discussions › Questions & Answers › Selecting Column Scope During Discoverer Folder Import
Customer · · Questions & Answers · 5 replies
When importing Discoverer folders, we want to restrict the resulting SQL to only the columns that were actively used by the worksheets, not every single column. Which profile setting controls this?
The profile option ‘Blitz Report Discoverer Folder Import Include Columns’ determines this scope. Setting it to ‘Active’ imports a SQL including columns used by the active Discoverer worksheets only.
What is the alternative setting if we wanted all columns, like a wildcard selection?
The alternative setting is ‘All’, which includes all columns of the accessed folders, resulting in syntax like `aia.*`.
What is the default configuration for this import option?
The default value for this profile is ‘Active’.
Sign in with LinkedIn or Google to take part.
