<< Click to Display Table of Contents >> Raynet One Data Hub > 14.0 > Administration and User Guide > Tasks > Naming Conventions > Naming Conventions for Tables Created by Importing Files into a Container  Importing XLS- or XLSX-Files

When importing one Excel file the following naming convention is applied.

 

•If the file only contains one sheet, the tablename will be identical to the dataset name of the task.

oExample: dbo.TaskDataSetname

•If the file contains multiple sheets, multiple tables will be created. The resulting table names will look as follows: the dataset name of the task followed by a - (minus), then the filename followed by a - (minus), and then the name of the sheet.

oExample: dbo.TaskDataSetname-Filename-Sheetname

 

When importing multiple Excel files the following naming convention is applied.

 

•For files that contain only one sheet, the tablename will be the dataset name of the task followed by a - (minus) and the filename.

oExample: dbo.TaskDataSetname-Filename

•For files that contain multiple sheets, multiple tables will be created. The resulting table names will look as follows: the dataset name of the task followed by a - (minus), then the filename followed by a - (minus), and then the name of the sheet.

oExample: dbo.TaskDataSetname-Filename-Sheetname