Hello Guru's,
Today Let me share a very important tip of Tableau,Creating Empty Extracts.
To achieve this we have a couple of ways and workarounds, let me share you the unique and easiest way of creating empty extracts by passing the unmatched datasource filter condition in the following steps.
Today Let me share a very important tip of Tableau,Creating Empty Extracts.
To achieve this we have a couple of ways and workarounds, let me share you the unique and easiest way of creating empty extracts by passing the unmatched datasource filter condition in the following steps.
Step1:-
Open Tableau Desktop and connect to the superstore English DataSource.
Step2:-
Go the Analysis Tab and click Create a Calculated Field
Step3:-
Give the Name as Empty Extract and In the Formula window write Now() And click on Ok.
Step4:-
Right Click on the Superstore Data Source and click on Edit Data Source Filters
Step5:-
In the Edit Data source Filters Window, Click on Add.
Step6:-
Select Empty Extract field and click on OK
Step7:-
Select Range of Dates and Click on Next
Step8:-
Click on Starting Date and Select 1 Minute Forward to the current date and time which results in the unmatched condition.
Click on Ok.
Step9:-
Again Right Click on the Superstore Datasource Click on Extract Data
Step10:-
In the Extract Data Window, Click on Extract
Step11:-
Save the Extract File and Click on View Data
It will Display No of rows=0 as below ,which indicates Extract is Empty.
Thanks Guru's,
Prazval.ks