Tableau Legacy Jet Drive – 7 Steps to Prepare Excel File with it

In this Tableau tutorial, we are going to study about a Tableau legacy jet drive, how to use Legacy Jet Drive in Tableau and the steps involved in creating the excel sheets for it.

Tableau Legacy Jet Drive

In this recipe, we will use the New York Restaurant Inspections Excel file and use the Tableau legacy Jet driver to shape the file so we can have both the inspection date and grade date in the same column. This will allow us to visualize how many restaurants were inspected and graded for a specific date:
Read about Tableau File Types With Their Extensions

Steps to Prepare the Excel File

These are the following steps to prepare excel file with Tableau Legacy Jet Drive, let’s discuss them one by one:

i. Click on New Data Source icon, and choose Excel:

Step- 1 Prepare Excel File With Legacy Jet Drive

ii. Choose DOHMH_New_York_City_Restaurant_Insepction_Result.xls, and select Open with Legacy Connection:

Step- 2 Prepare Excel File With Legacy Jet Drive

Let’s Discuss Tableau Data Sources in detail

iii. In the Connection window, remove the existing connection to the one sheet in the Excel file:

Step- 3 Prepare Excel File With Legacy Jet Drive

iv. Drag New Custom SQL to the main connection pane:

Step- 4 Prepare Excel File With Legacy Jet Drive

Learn How to Add Worksheets And Renaming Worksheet in Tableau

v. Add the following code to the Edit Custom SQL window:
SELECT
[ DBA],
[ CAMIS],
[CUISINE DESCRIPTION],
[ INSPECTION DATE],
[ GRADE DATE],
[INSPCTION DATE] AS [Date],
‘Inspected’ AS [Type]
FROM [DOHMH New York City Restaurant$]
UNION ALL
SELECT
[ DBA],
[ CAMIS],
[CUISINE DESCRIPTION],
[ INSPECTION DATE],
[ GRADE DATE],
[GRADE DATE] AS [Date],
‘Graded’ AS [Type]
FROM [DOHMH New York City Restaurant$]
Read about Tableau Date Functions with Examples
vi. In the preview window, click on the Abc symbol above the Date field and select Date to change the data type to Date:

Step- 6 Prepare Excel File With Legacy Jet Drive

vii. Add a new sheet and create your visualization using this data set.

Conclusion

In this tutorial, we learned how to use Tableau legacy jet drive, how to create excel files with it and many other things. Furthermore, if you have any query feel free to ask in a comment section.