CODEWITHSUNDEEP
ckan
Daniel
Daniel

Reputation: 754

CKAN Joining resources and datasets

I'm looking for an easy way to create / explore / view new datasets. This datasets are just the result of an inner join between join compatible resources.

Take for instance dataset A:

year, debt
2010, 1000
2011, 900
2012, 800

And dataset B:

year, earnings
2010, 20000
2011, 18000
2012, 23000

I would like to dinamically be able to explore the dataset A join B:

year, earnings, debt
2010, 1000, 20000
2011, 900, 18000
2012, 800, 23000

I have checked in the extensions website but couldn't find anything.

Any clues?

Upvotes: 0

Views: 361

Answers (1)

D Read
D Read

Reputation: 3224

You can run a SQL query that joins the tables by passing it to the datastore_search_sql API, which is documented here: http://docs.ckan.org/en/latest/maintaining/datastore.html#ckanext.datastore.logic.action.datastore_search_sql

Upvotes: 1

Related Questions