nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Relations among multiple datasets with source as csv.

srikala

how to form a relation among datasets when the source is csv file. 
its like a star schema , one fact table surrounded by multiple dimension tables. 
In the same way we need to relate all the csv files and make a single join dataset. 
Is that possible using BIRT, if so could you please guide us.

Find more posts tagged with

Comments

thuston

Make your two csv DataSets, then make a third "Join DataSet" and specify the join columns.

srikala

we want to join multiple datasets not just two datasets

thuston

I think you can only do two at a time. But you can join dataSets that are already join DataSets.

For 3 csv you'll make 5 DataSets.
DS1
DS2
DS3
JDS1 (DS1 + DS2)
JDS2 (JDS1 + DS3)

You'd be much better off if you start storing these csvs in a database.
But the above should allow you to work with what you have.