{"id":12404,"date":"2018-04-06T12:44:50","date_gmt":"2018-04-06T12:44:50","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=12404"},"modified":"2025-03-01T19:30:21","modified_gmt":"2025-03-01T14:00:21","slug":"tableau-legacy-jet-drive","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/tableau-legacy-jet-drive\/","title":{"rendered":"Tableau Legacy Jet Drive – 7 Steps to Prepare Excel File with it"},"content":{"rendered":"

In this Tableau\u00a0tutorial<\/a><\/strong>, 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.<\/p>\n

Tableau Legacy Jet Drive<\/h3>\n

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:
\nRead about Tableau File Types With Their Extensions<\/a><\/strong><\/p>\n

Steps to Prepare the Excel File<\/h3>\n

These are the following steps to prepare excel file with\u00a0Tableau Legacy Jet Drive, let’s discuss them one by one:<\/p>\n

i. Click on New Data Source icon, and choose Excel:<\/p>\n

\"Tableau<\/a>

Step- 1 Prepare Excel File With Legacy Jet Drive<\/p><\/div>\n

ii. Choose DOHMH_New_York_City_Restaurant_Insepction_Result.xls<\/strong>, and select Open with Legacy Connection:<\/p>\n

\"Tableau<\/a>

Step- 2 Prepare Excel File With Legacy Jet Drive<\/p><\/div>\n

Let’s Discuss Tableau Data Sources in detail<\/strong><\/a><\/p>\n

iii. In the Connection window, remove the existing connection to the one sheet in the Excel file:<\/span><\/p>\n

\"Step-<\/a>

Step- 3 Prepare Excel File With Legacy Jet Drive<\/p><\/div>\n

iv. Drag New Custom SQL to the main connection pane:<\/p>\n

\"Tableau<\/a>

Step- 4 Prepare Excel File With Legacy Jet Drive<\/p><\/div>\n

Learn How to Add Worksheets And Renaming Worksheet in Tableau<\/strong><\/a><\/p>\n

v. Add the following code to the Edit Custom SQL window:
\nSELECT <\/strong>
\n[ DBA],<\/strong>
\n[ CAMIS],<\/strong>
\n[CUISINE DESCRIPTION], <\/strong>
\n[ INSPECTION DATE],<\/strong>
\n[ GRADE DATE],<\/strong>
\n[INSPCTION DATE] AS [Date], <\/strong>
\n‘Inspected’ AS [Type]<\/strong>
\nFROM [DOHMH New York City Restaurant$]<\/strong>
\nUNION ALL<\/strong>
\nSELECT <\/strong>
\n[ DBA],<\/strong>
\n[ CAMIS],<\/strong>
\n[CUISINE DESCRIPTION], <\/strong>
\n[ INSPECTION DATE],<\/strong>
\n[ GRADE DATE],<\/strong>
\n[GRADE DATE] AS [Date], <\/strong>
\n‘Graded’ AS [Type] <\/strong>
\nFROM [DOHMH New York City Restaurant$]<\/strong>
\nRead about Tableau Date Functions with Examples<\/strong><\/a>
\nvi. In the preview window, click on the Abc symbol above the Date field and select Date to change the data type to Date:<\/p>\n

\"legacy<\/a>

Step- 6 Prepare Excel File With Legacy Jet Drive<\/p><\/div>\n

vii. Add a new sheet and create your visualization using this data set.<\/p>\n

Conclusion<\/h3>\n

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.<\/p>\n","protected":false},"excerpt":{"rendered":"

In this Tableau\u00a0tutorial, 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...<\/p>\n","protected":false},"author":5,"featured_media":12551,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[71],"tags":[5910,8202,14335,14336],"class_list":["post-12404","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tableau","tag-how-legancy-jet-drive-works","tag-legacy-jet-drive-in-tableau","tag-tableau-legacy-jet-drive","tag-tableau-legacy-jet-drive-example"],"yoast_head":"\nTableau Legacy Jet Drive - 7 Steps to Prepare Excel File with it - DataFlair<\/title>\n<meta name=\"description\" content=\"What is Tableau Legacy Jet Drive with example. See Easy Steps to Prepare Excel file with Legacy Jet drive in a tableau etc.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/tableau-legacy-jet-drive\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tableau Legacy Jet Drive - 7 Steps to Prepare Excel File with it - DataFlair\" \/>\n<meta property=\"og:description\" content=\"What is Tableau Legacy Jet Drive with example. See Easy Steps to Prepare Excel file with Legacy Jet drive in a tableau etc.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/tableau-legacy-jet-drive\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-04-06T12:44:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-01T14:00:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/04\/Using-legacy-jet-drive-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Tableau Legacy Jet Drive - 7 Steps to Prepare Excel File with it - DataFlair","description":"What is Tableau Legacy Jet Drive with example. See Easy Steps to Prepare Excel file with Legacy Jet drive in a tableau etc.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/tableau-legacy-jet-drive\/","og_locale":"en_US","og_type":"article","og_title":"Tableau Legacy Jet Drive - 7 Steps to Prepare Excel File with it - DataFlair","og_description":"What is Tableau Legacy Jet Drive with example. See Easy Steps to Prepare Excel file with Legacy Jet drive in a tableau etc.","og_url":"https:\/\/data-flair.training\/blogs\/tableau-legacy-jet-drive\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-04-06T12:44:50+00:00","article_modified_time":"2025-03-01T14:00:21+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/04\/Using-legacy-jet-drive-01.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/tableau-legacy-jet-drive\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-legacy-jet-drive\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823"},"headline":"Tableau Legacy Jet Drive – 7 Steps to Prepare Excel File with it","datePublished":"2018-04-06T12:44:50+00:00","dateModified":"2025-03-01T14:00:21+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-legacy-jet-drive\/"},"wordCount":426,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-legacy-jet-drive\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/04\/Using-legacy-jet-drive-01.jpg","keywords":["how legancy jet drive works","Legacy Jet Drive in Tableau","Tableau Legacy Jet Drive","Tableau legacy jet drive example"],"articleSection":["Tableau Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/tableau-legacy-jet-drive\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/tableau-legacy-jet-drive\/","url":"https:\/\/data-flair.training\/blogs\/tableau-legacy-jet-drive\/","name":"Tableau Legacy Jet Drive - 7 Steps to Prepare Excel File with it - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-legacy-jet-drive\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-legacy-jet-drive\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/04\/Using-legacy-jet-drive-01.jpg","datePublished":"2018-04-06T12:44:50+00:00","dateModified":"2025-03-01T14:00:21+00:00","description":"What is Tableau Legacy Jet Drive with example. See Easy Steps to Prepare Excel file with Legacy Jet drive in a tableau etc.","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-legacy-jet-drive\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/tableau-legacy-jet-drive\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/tableau-legacy-jet-drive\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/04\/Using-legacy-jet-drive-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/04\/Using-legacy-jet-drive-01.jpg","width":1200,"height":628,"caption":"Tableau Legacy Jet Drive"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/tableau-legacy-jet-drive\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Tableau Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/tableau\/"},{"@type":"ListItem","position":3,"name":"Tableau Legacy Jet Drive – 7 Steps to Prepare Excel File with it"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"DataFlair Team creates expert-level guides on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our goal is to empower learners with easy-to-understand content. Explore our resources for career growth and practical learning.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam1\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/12404","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=12404"}],"version-history":[{"count":5,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/12404\/revisions"}],"predecessor-version":[{"id":144412,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/12404\/revisions\/144412"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/12551"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=12404"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=12404"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=12404"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}