I would like to know if there is a way to ‘merge’ 2 different datasources
DataSource A : [ id | age | visit in web site ]
DataSource B: [ id | country | visit in shopping center]
in both datasources id is the same (its unique user id like his mobile device identifier) , age and county are dimensions and number of visit in web site or shopping center is metric
can I merge them to new datasource like
[ id | age | country | #visit in web site | #visit in shopping center ] ?
I used datasource combined option but it works only if both datasources schema are identical
If answer is NO ! , is there away to query from those datasources like its one or configure Pivot to do this task ?