Create Upload Tables
Info:
There are important Naming Guidelines to follow when choosing worksheet and column names.
The default way to upload your data into Valsight are regular tables. These tables are organized like a classic relational table.
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.