Apply syncset from one datasource to another data source

Apps (Frontend)
1

Hi,

I have a syncset which is applied on the data_scenario_projections data source and I would like to apply it to another data source as well, called data_scenario_projections_extended.

These two data sources are then displayed in an app and I would like that all the filters (i.e., joins specified in the syncset) are applied to the data_scenario_projections_extended as well.

Is there any way to do that? I tried to apply and use syncMaps, but did not manage to make my filters be applied on both datasets: SyncSets : ONE DATA Service Center.

Here is the code to my syncset:

{
  "id": "syncSet_scenario_projections_table",
  "sources": [
    "data_scenario_projections"

  ],
  "joins": [
    {
      "datasource": "data_scenario_projections",
      "columns": [
        "level1_id",
        "type",
        "level2_id",
        "level3_id",
        "scenario_name"
      ]
    }
  ],
  "syncMap": [
    {
      "source": "data_scenario_projections",
      "targets": [
        "data_scenario_projections"

      ]
    }
  ]
}

Thank you in advance!

2

I think you have to try something like this below:
syncMap should not be relevant by the way:
The order of the columns does matter (see screenshot)
image

{
  "id": "calendar_week_syncSet",
  "sources": [
    "data_scenario_projections",
    "data_scenario_projections_extended"
  ],
  "joins": [
    {
      "datasource": "data_scenario_projections",
    "columns": [
        "level1_id",
        "type",
        "level2_id",
        "level3_id",
        "scenario_name"
      ]
    },
    {
      "datasource": "data_scenario_projections_extended",
    "columns": [
        "level1_id",
        "type",
        "level2_id",
        "level3_id",
        "scenario_name"
      ]
    }
  ],
  "syncMap": []
}
3

I modified the syncset exactly as you suggested @johannesheininger, and now the data sources no longer load in the app. Instead, the app is stuck showing the “Preparing data” icon:

image
image776×521 9.06 KB

4

I mean it should be something like that, but as I do not know your full setup I can not write the exact code/config for you of course.

5

Solved using the following syncset, which is applied on both data sources at the same time.

Cheers to @melchior.rb for implementing the solution:

{
  "id": "syncSet_scenario_projections_table",
  "sources": [
    "data_scenario_projections",
    "data_scenario_projections"
  ],
  "joins": [
    {
      "datasource": "data_scenario_projections",
      "columns": [
        "level1_id",
        "type",
        "level2_id",
        "level3_id",
        "scenario_name",
        "qc_filter_description",
        "product"
      ]
    },
    {
      "datasource": "data_scenario_projections_extended",
      "columns": [
        "level1_id",
        "type",
        "level2_id",
        "level3_id",
        "scenario_name",
        "qc_filter_description",
        "product"
      ]
    }
  ],
  "syncMap": [
    {
      "source": "data_scenario_projections",
      "targets": [
        "data_scenario_projections"
      ]
    },
    {
      "source": "data_scenario_projections_extended",
      "targets": [
        "data_scenario_projections_extended"
      ]
    }
  ]
}