Create Upload Tables
The default way to upload your data into Valsight are regular tables. These tables are organized like a classic relational table.
Important Follow the Naming Guidelines when choosing worksheet and column names.
These tables can contain zero or more levels, they are the most flexible way to upload data.
Some examples:
A table with no dimensional information, not even time:
| Measure |
|---|
| 10 |
A table that contains one numeric value per year:
| Year | Inflation |
|---|---|
| 2018 | 2% |
| 2019 | 3% |
A table that contains multiple numeric values per year:
| Year | Inflation | InterestRate |
|---|---|---|
| 2018 | 2% | 4% |
| 2019 | 3% | 5% |
A table that contains two levels and multiple values
| Year | Country | Inflation | InterestRate |
|---|---|---|---|
| 2018 | DE | 2% | 4% |
| 2019 | DE | 3% | 5% |
| 2018 | US | 4% | 2% |
| 2019 | US | 2% | 3% |
See an Example at Example Excel Sheets.