vividime Community

title: Excel dataset [Print this page]

author: vividime-Club time: 2024-11-26 15:13
title: Excel dataset
how to use Excel dataset？

author: vividime-Club time: 2024-11-26 15:13

1. Create Excel Dataset

There are two ways to enter the Create Dataset page:

•Click the icon at the top left of the dataset page to enter the new dataset page. Click Excel dataset to enter the creation page.

•On the New Connection page, select EXCEL&TEXT.

2. Upload data to Excel dataset

2.1 Upload Excel

??/text>

•Upload

[td]

Function	Explain
Upload	Click Upload to pop up a dialog box, where you can select single or multiple files to upload. Description: This corresponding item in vividime Desktop is called "Open". When uploading multiple files at one time, the file type must be the same. For example,. xlsx+. xlsx files are supported, but. xlsx+. csv files are not.
Sheet	The Sheet lists all uploaded files. If the file type is Excel, the name of all Excel and sheet tables will be listed in the worksheet. The first sheet of each Excel file will be selected by default. Excel and sheet lists can be selected one or more times according to requirements. •By default, Merge into a Dataset is selected. The number of columns in the first sheet table and the data type of the column will be matched. oA prompt will pop up when the number of columns in the sheet following the first does not match the number of columns in the first sheet. oWhen the number of the following sheet table columns does not match the data type of the first sheet table column, it will be displayed according to the data type of the first sheet table. •Select Generate Multiple Datasets, and then click OK. The following save dialog box will pop up. Click OK after confirming or modifying the file name. It supports data consolidation of multiple Excel files. Metadata depends on the first file, and the consolidation rules are the same as those of the sheet.

•Advanced Setting

[td]

Function		Explain
advanced Settings	Loading Way	Table: directly use the original data of the file. Generate Unpivot Table: convert the column data of the file into row data before use.
	Start Line	The number of rows from which data is read. The default value is 1.
	Header	Include Auto, First line, and None. •Auto: indicates that the system automatically judges the header line •First Line: the first row of each sheet table is used as the header row. •None: indicates that each sheet table has no header row, and the contents in the sheet table are processed according to data.
	Delete Invalid Rows	By default, data is not deleted when uploading Excel. If Delete Invalid Line is checked, the system will automatically delete unreasonable data lines. For example: If 9 out of 10 data in a row in a data row is empty, the system will automatically delete this row.
	Refresh Data	If the uploaded file changes, click Refresh Data to refresh metadata and data details.

When the loading method is selected to generate an unpivot table, the cross type table with row header and column header will be generated into a normal table with row header only. The interface changes as follows:

The meanings of the new attributes are as follows:

[td]

Attribute	Explain
Row Header Level	The number of row headers of the uploaded table.
Column Header Level	The number of column headers of the uploaded form.

Example of inverse perspective:

1) As shown in the figure, the number of row headers is 1, and the number of column headers is 2:

2) Upload, check to generate the reverse pivot table, and set the row header level to 1, and the column header level to 2:

3) Refresh the metadata to process the data in the table, that is, 1 row header data, 2 column header data and data are all listed as one column, and the data is listed from top to bottom, from left to right, and in the order corresponding to the row/column header data. The data when previewing the dataset is:

2.2 Upload CSV/TXT/LOG

•Advanced Setting

The file interface for uploading CSV is the same as that for TXT and LOG formats. The advanced settings support the attributes of encoding type and separator. For other functions, refer to Upload Excel.

[td]

Attribute	Explain
Encode	When the uploaded file is selected, the system will automatically load the corresponding encoding type, or you can select from the drop-down box as required. The available encoding types include: UTF-8, GB18030, UTF-16BE, UTF-16LE, and ASCII.
Separator	The separator is automatically detected. You can also select a separator from the drop-down box. Optional separator types include comma, semicolon, vertical bar, tab, space, and custom. When you select Custom, you can enter the required separator by yourself.

3. Desktop data update

The Desktop supports automatic updating of row data of Excel files: after uploading Excel and CSV files, save the dataset. When the row data of local Excel and CSV files are updated (added, deleted, modified), the Excel dataset in the Desktop automatically updates the data.

The Desktop supports the reminder of updating the column data of Excel files: after uploading the Excel file, save the dataset. When the column data of the local Excel file is updated (added, deleted, modified), and the corresponding Excel dataset is opened on the desktop, a prompt "Dataset name+local data are updated, please refresh the data in time!" pops up.

Description:

Only Desktop supports Excel automatic update. Server and Y-Vivid show do not have this function.

4. Upload/open files, edit and delete files

Open/Upload File: click Open/Upload and select the Excel file in the corresponding path to upload.

Edit File: After uploading the file, if you need to update the data in the Excel file, click the edit icon to open the corresponding local file for editing.

Delete File: After uploading a file, click the Delete icon to delete the file.

➢Description:

Currently, only Desktop is supported for editing files, not server side.

Welcome vividime Community (https://club.vividime.com/)