1. Identify the Workbook which contains the Old connection
2. Identify the Data Source which needs to be edited within the Workbook
3. Save the Data Source to an .XML file (.twbs) on a local file system
4. Open the .twbs file in a Notepad or Notepad++
5. Create an Excel spreadsheet with the original table names, column names and the corresponding new table and column names
6. Need to search the file for the “Old tables” names listed in the .twbs
a. Note down the line numbers or save the output in to an excel or ascii file
b. Edit the old columns names also in the entire file
c. Edit the join criteria with the right join condition (inner as opposed to full outer)
7. Upon completion of the changes, search for any old values if any
8. Open the .twbs in tableau desktop and ensure that there are no errors
9. Now open the workbook and replace the old datasource with new one.
ReplyDeleteNice post ,keep update at
Tableau Online Training
Nice Blog ! For getting more information and fixing your QuickBooks issues, dial our QuickBooks Toll Free Phone Number 1-800-986-4607 for QuickBooks error.
ReplyDeleteView on Map: https://tinyurl.com/ut8xnsx
Facing issues in QuickBooks? Dial QuickBooks Customer Support & get effective solutions from our QuickBooks experts. Our support team consists of a large panel of experts who give reliable aid to the users. For More: https://g.page/quickbookssupporttexas
ReplyDeleteEven people who are experts at using Microsoft Excel don't often venture into the area of macros. Learn to control macros that allow you to create dialogue boxes, custom forms, and other objects to take communication between the spreadsheet and the user to new heights. excel spreadsheet help
ReplyDeleteI feel tableau and other aspects really help one look more about the emerging and useful aspects and features of tableau to look forward.
ReplyDeleteTableau Rest Api Connection
Nice and good article. It is very useful for me to learn and understand easily. Thanks for sharing
ReplyDeleteTableau Online Training in Hyderabad
Best Online Tableau Training
I truly appreciate the time and work you put into sharing your knowledge. I found this topic to be quite effective and beneficial to me. Thank you very much for sharing. Continue to blog.
ReplyDeleteData Engineering Services
AI & ML Solutions
Data Analytics Services
Data Modernization Services