Mapping/ Join SQL and CSV Data
Options
Ellina Mnikh
Customer
Hi all,
I'm quite new in Board and would be happy to get an advice to my topic. I use ASCII Data Reader to get the inventory data from a csv. To get some additional information like material description I add a database table Material via SQL protocol. Both of them have a common column calling Material code.
I would like to show the inventory data and material description in one dataview. So I'm wondering, if here would be a way to join the data?
Some of my settings:
Data Reader:
ASCII: Inventory
Day Owner MaterialCode Material Quantity
SQL: Material Data
MaterialCode MaterialGroup
Relationships:
MaterialGroup - MaterialCode - Material
Cube:
Day MaterialCode Owner
Reportidea:
Thank you in advance,
Ellina
------------------------------
Ellina Mnikh
Controller
------------------------------
I'm quite new in Board and would be happy to get an advice to my topic. I use ASCII Data Reader to get the inventory data from a csv. To get some additional information like material description I add a database table Material via SQL protocol. Both of them have a common column calling Material code.
I would like to show the inventory data and material description in one dataview. So I'm wondering, if here would be a way to join the data?
Some of my settings:
Data Reader:
ASCII: Inventory
Day Owner MaterialCode Material Quantity
SQL: Material Data
MaterialCode MaterialGroup
Relationships:
MaterialGroup - MaterialCode - Material
Cube:
Day MaterialCode Owner
Reportidea:
Thank you in advance,
Ellina
------------------------------
Ellina Mnikh
Controller
------------------------------
Tagged:
0
Answers
-
Hi Elina,
I don't believe that the data source is a problem.
I would try with a cube at the lowest level to show what you need: Day, Material,Owner instead of Day, Material Code, Owner
You should then be able to insert the 3 dimensions in the rows of the dataview.
Best,
------------------------------
Sébastien Breyne
Finance Manager
Cullen International
Belgium
------------------------------
-------------------------------------------0
Categories
- All Categories
- 1.8K Forums
- 1.7K Platform
- 106 Academy
- 280 Resources
- 3 Community Captains
- 1 About Community Captains
- 1 Meet the Community Captains
- 1 Topics & Thought Starters
- Board Manual
- 50 Best Practices
- 41 How-To Guides
- 25 Board Advocacy Program
- 157 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
- 305 Partner Hub
- 2 Solution Sales Toolkits
- 91 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP