[ckan-dev] Join resources

[Stefan Oderbolz]

Hi Daniel

if the resources are stored in the DataStore (
http://docs.ckan.org/en/ckan-2.7.3/maintaining/datastore.html), you can
actually run arbitrary SQL statements on them including an inner join on
them (
http://docs.ckan.org/en/ckan-2.7.3/maintaining/datastore.html#ckanext.datastore.logic.action.datastore_search_sql).
Is this what you've been looking for?

https://demo.ckan.org has DataStore enabled, so you could try it there.

- Stefan



On Mon, Apr 9, 2018 at 10:05 PM, Daniel Foguelman <dj.foguelman at gmail.com>
wrote:

> Dear all,
>
> 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 (extensions.ckan.org) but
> couldn't find anythin.
>
> Any clues?
>
>
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/ckan-dev
> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
>
>


-- 
Liip AG  // Limmatstrasse 183 //  CH-8005 Zürich
Tel +41 43 500 39 80 // GnuPG 0x7B588C67 // www.liip.ch
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20180410/b1892302/attachment-0003.html>