Is the datasource a flat file (Excel /CSV ) or from some database like Oracle / MS SQL ?
it is database(oracle 11g)
yes..it is database (oracle 11g)
One option is to create a view on top of the table and get the required columns in the view and you can use the same view to consume in tableau.
thanks for help Chandrashekhar .but we want to automate some process of which this is on of simple part. If we make a view would it be good solution? because it won't be dynamic as if we need to add or remove column then each time I will have to create another view so can there be another solution which will provide dynamism in automating process
Finally got solution for this problem and thanks Chandrasekar Ganapathy for help..and the solution is you can hide columns which you don't want to consider and proceed further and when you hide columns tableau will not get those column from data source(So question of bandwidth occupation will not be raised )
Even more, Tableau will not query unused columns with two exceptions:
- Establishing new connection will query table's metadata (but not the column's data)
- During extract creation Tableau will query all the visible columns, regardless whether they are used or not
An, in general, Tableau doesn't ask for row-level data so amount of data fetched is pretty low.
Curious, what environment are you dealing with where this is a concern?