How to import a table from a text file (.txt)

Open Excel.
(1) Click on the Vizubi Tab in the ribbon bar.
(2) Click on the Edit button in the database group.
(3) This will open the Import Data window.

(1) Select Delimited text file as the Data Source Type.
(2) Use the Browse button "…" to select "C:\Documents and Settings\All Users\Documents\Vizubi\SampleData\txt\InvoicesFromDB.txt". The name of the file appears in the Friendly name.
(3) Select the delimiter by clicking on the down arrow to the left of Text Delimiter. The Text Delimiter is the symbol that separates columns in a text file.
(4) Select the Text qualifier by clicking on the down arrow to the right of text qualifier, which is the symbol that identifies a text string in a .txt file (not all .txt files have a text qualifier).
(5) If the first row of your .txt file contains column headers (column names), then keep the Column header on first row check box selected. Make sure to deselect it if this is not the case otherwise your first row of data will be placed into the column names and not imported as data.
(6) Click on Next.

The Preiew window shows the first 50 rows of data in line with the import parameters you defined in the previous step.

(1) You can change the type of data in any column by clicking on the icon to the left of the column header (you can select from General, Number and Date).
(2) You can choose not to import a column by clicking on the check box to the right of the column header.
(3) Click on Next.

In the Time dimensions window, Vizubi shows fields which were formatted as time. These fields can be used to analyze your data against time so that (for instance) you can automatically see sales for this year vs. last year. Vizubi will also automatically create slicers and panels used for filtering data for all time dimensions.

(1) OrderDate was formatted as a Date field in the previous step so Vizubi defines it as a time dimension. CTRL + click will deselect rows so that time dimension will not be created (you can also deselect or select all the rows by clicking on the appropriate buttons).
(2) You can change the name that will be displayed for time dimensions by clicking in the label column in the row of the time dimension you want to modify.
(3) Click on Next.

The Import Data window shows you all the parameters you set in the previous steps. In some cases you may want to skip the import step and merely save the import parameters to import the data at a later time (if for instance you want to wait until servers and networks are not busy).

(1) If you want to modify any of the parameters you set in previous steps, click on the Back button.
(2) Click on Import to import the data.
(3) Click on Save to save the import parameters.

(1) The active label InvoicesFromDB shows the data imported.
(2) The label OrderDate it’s the time dimension that Vizubi found during the import.

Open Excel.
(1) Click on the Vizubi Tab in the ribbon bar.
(2) Click on the Edit button in the database group.
(3) This will open the Import Data window.

(1) Select Delimited text file as the Data Source Type.
(2) Use the Browse button "…" to select "C:\Documents and Settings\All Users\Documents\Vizubi\SampleData\txt\InvoicesFromDB.txt". The name of the file appears in the Friendly name.
(3) Select the delimiter by clicking on the down arrow to the left of Text Delimiter. The Text Delimiter is the symbol that separates columns in a text file.
(4) Select the Text qualifier by clicking on the down arrow to the right of text qualifier, which is the symbol that identifies a text string in a .txt file (not all .txt files have a text qualifier).
(5) If the first row of your .txt file contains column headers (column names), then keep the Column header on first row check box selected. Make sure to deselect it if this is not the case otherwise your first row of data will be placed into the column names and not imported as data.
(6) Click on Next.

The Preiew window shows the first 50 rows of data in line with the import parameters you defined in the previous step.

(1) You can change the type of data in any column by clicking on the icon to the left of the column header (you can select from General, Number and Date).
(2) You can choose not to import a column by clicking on the check box to the right of the column header.
(3) Click on Next.

In the Time dimensions window, Vizubi shows fields which were formatted as time. These fields can be used to analyze your data against time so that (for instance) you can automatically see sales for this year vs. last year. Vizubi will also automatically create slicers and panels used for filtering data for all time dimensions.

(1) OrderDate was formatted as a Date field in the previous step so Vizubi defines it as a time dimension. CTRL + click will deselect rows so that time dimension will not be created (you can also deselect or select all the rows by clicking on the appropriate buttons).
(2) You can change the name that will be displayed for time dimensions by clicking in the label column in the row of the time dimension you want to modify.
(3) Click on Next.

The Import Data window shows you all the parameters you set in the previous steps. In some cases you may want to skip the import step and merely save the import parameters to import the data at a later time (if for instance you want to wait until servers and networks are not busy).

(1) If you want to modify any of the parameters you set in previous steps, click on the Back button.
(2) Click on Import to import the data.
(3) Click on Save to save the import parameters.

(1) The active label InvoicesFromDB shows the data imported.
(2) The label OrderDate it’s the time dimension that Vizubi found during the import.