Creating CSV Tables

CSV tables retrieve data from CSV files stored in the File Cabinet. Unlike static tables, CSV tables don't store data in the table record and you can use them for large tables to avoid the one-million character limit. To update a CSV tables, you can upload a CSV file with the same name to the File Cabinet.

Before completing the steps to create a CSV table, follow the basic steps to create a table.

To create a CSV table:

  1. On the Tables subtab, click New CPQC Table.

  2. In the Table Type field, select CSV Table.

  3. In the CSV File field, select the CSV file you want to use as the data source.

  4. In the Column Separator field, select the symbol that separates the columns of the CSV file, for example, a comma or a semicolon.

  5. In the Escape Characters field, select the character used to indicate that the following character should be interpreted literally, or to enclose text with special characters.

  6. Click Save.

Related Topics

General Notices