Editing Connections in Tableau

Data

Editing Connections in Tableau

by Matt Fowler
//

A Quick Way to Reengineer Worksheets & Workbooks for New Data – 

Imagine you are receiving updated versions of the same or similar set of data.  Possibly, you are sent an excel file each week with the current market data, or perhaps a colleague that works for your company, within a different business unit, would like to copy your analysis in Tableau using his or her data set.  IE – How do I easily update this worksheet or workbook if the data changes exist within an entirely different data source?  If you wish to utilize existing worksheets and workbooks with new or different data, you may do so by editing the data connection within Tableau.  This very simple process will allow you to apply new data against an existing analysis without having to completely reengineer the view.


The steps are as follows:


1 – Build a worksheet, or open an existing worksheet.



2 – From the Data menu select:  Data > “Name of Your Data Connection” > Edit Connection

 

3 – Select the new/different data file you would like to run as the existing worksheet source file (Note- You can also rename the connection under “Step 4” within the dialog menu, as it will maintain the existing data connection name Ex- “Example Data 1”)


 

4 – Replace references for any field name changes:  Right Click on “Field Name” > Replace References
(*If field names are identical this step is not required)

 

5 – Select the corresponding field name and Tableau will now recognize the new field. (“Number of Units” to “Units Sold”)

 

The worksheet has now been updated to reflect the changes within my new data set.

ORIGINAL

FINAL

(Note- The addition of fields does not require additional steps Ex- “Cost”)

 

For any questions or comments regarding this post or general topics, please feel free to leave a comment or send an email.

More About the Author

Matt Fowler

Business Intelligence Analyst
DATART – Using Tableau & Superstore to Create Digital Art As a data analyst, it’s fitting that I love data. The information we can gather, allowing us to learn more about our world, understand ...
Aggregating With Extracts – Why and How Would I Do Such a Thing? So, Here’s the “Why” In Tableau, we are easily able to slice and dice the data according to our dimensions thanks to ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072