1 of 1 people found this helpful
Could you provide the screen shot of the view that you are exporting? The other way to export right content would be to create a worksheet without those measure names and values, hide it (if necessary) and use tabcmd to export it.
2 of 2 people found this helpful
Thanks for answering Sharad.
But yes, finally I've done this. If anyone is interested:
- Preparation: we need to drag the measures to the Detail, otherwise Tableau will not export that data.
2. Create batch file using tabcmd: tabcmd export "Workbook/View" --csv -f "C:\Tableau\view.csv" --timeout 480
Here I’ve added as well the powershell script that you’ll see next step:
cd /d C:\Tableau
PowerShell.exe Set-ExecutionPolicy Bypass
PowerShell.exe -File "G:\Tableau\script.ps1"
3. Tableau export the Measures Values and Measures Names as columns and these need to be removed. This script imports the file, select and order the columns that we want and locate the final report. Please notice I'm using - Unique because the MeasuresValues and MeasureNames columns generate duplicates.
Import-Csv C:\Tableau\View.csv | select ID, Name, Date | sort ID -Unique | Export-Csv -Path C:\Tableau\View.csv –NoTypeInformation
4. Finally, use Task Scheduler for scheduling these batch files.
Hope it helps!
Could you please provide the scripts for all above batch files.
Thanks in advance!!