Map entity to column headers in ASCII Data reader
Options
Nitish Subramanian
Active Partner
Hi,
I have come across a few clients who have excel data available with them, its easy to ask the clients to convert it into a .csv file and load it into Board. But then we have a specific format to follow here. Data should always be by columns, i.e., headers should be in columns and members in rows.
Instead if we can create a feature where we have data in a pivot/ crosstab format and we can map entity directly to the row/ column headers and load data into cubes in Board.
An example is attached as a word doc with this idea. Please note in the example mentioned, we have Month names on columns, but in actual scenario it can be any entity that we have in Board.
I have come across a few clients who have excel data available with them, its easy to ask the clients to convert it into a .csv file and load it into Board. But then we have a specific format to follow here. Data should always be by columns, i.e., headers should be in columns and members in rows.
Instead if we can create a feature where we have data in a pivot/ crosstab format and we can map entity directly to the row/ column headers and load data into cubes in Board.
An example is attached as a word doc with this idea. Please note in the example mentioned, we have Month names on columns, but in actual scenario it can be any entity that we have in Board.
9
Categories
- All Categories
- 1.8K Forums
- 1.7K Platform
- 109 Academy
- 283 Resources
- 3 Community Captains
- 1 About Community Captains
- 1 Meet the Community Captains
- 1 Topics & Thought Starters
- Board Manual
- 50 Best Practices
- 42 How-To Guides
- 25 Board Advocacy Program
- 159 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- Academy
- 2 Board Academy
- 7 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.1K Idea Exchange
- 310 Partner Hub
- 2 Solution Sales Toolkits
- 92 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP