After connected to a data source now we have to export the connection data as an alternate route which permits rapid connections without opening the connection dialog box.
If you frequently connect to the similar data source several times or if you have joined custom fields to the Data window like calculated fields, and binned fields or added joined tables. For following connections to that source, use the alternate route or shortcut so that you don’t have to re-establish the custom fields.
Note that: By saving the workbook or by creating a bookmark file you can also save custom fields.Previous Next
Learn SQL in 16 hrs from experts