Maintaining header rows and columns when uploading dataset?
I have a table in excel which has both header columns and header rows. I want to build a dashboard so salespeople can pick which columns they want to display in the table to give to clients. When I upload the dataset to Domo, I select crosstab, but then all of my columns are lost and rows are duplicated for each column. Is there a way to maintain the table's format with all the columns intact?
Best Answer
-
what is a "header row". if it's a column that labels or identifies a row, in traditional database nomenclature we'd just call that the row_id or primary_key.
if that's the case, then there's no reason to import as a crosstab. just import it as a normal dataset. then you can use filters to choose which rows to show and column headers to choose which columns to display.
Jae Wilson
Check out my Domo Training YouTube Channel
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- 10.6K All Categories
- 1 APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 339 Workbench
- 252 Domo Best Practices
- 11 Domo Certification
- 461 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 63 Kowaza
- 296 仲間に相談
- 649 ひらめき共有