Create Upload Tables

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.


Was this helpful?

Yes | Somewhat | No