Created question in FIWARE Q/A platform on 23-11-2023 at 15:11
Please, ANSWER this question AT https://stackoverflow.com/questions/77537711/quantumleap-store-the-same-model-with-different-columns-in-two-tables-timescal

Question:
QuantumLeap: store the same model with different columns in two tables (timescale)

Description:
I am using NGSI-LD and Orion Context Broker v1.4.
I need to store in two independent tables that start data from the same model but have different attributes.
If I use two subscriptions it stores them in the same table.
1 Subscription:
{
"description": "Store vehicle data",
"type": "Subscription",
"entities": [

],
"watchedAttributes": ["alternateName", "color", "license_plate", "name"],
"notification": {
"attributes": ["id", "alternateName", "color", "license_plate", "name"],
"format": "normalized",
"endpoint": {
"uri": "qunatumleap:8668/v2/notify",
"accept": "application/json"
}
}
}

2 Subscription:
{
"description": "Store dynamic data",
"type": "Subscription",
"entities": [

],
"watchedAttributes": ["location", "heading", "speed"],
"notification": {
"attributes": ["id","location", "heading", "speed"],
"format": "normalized",
"endpoint": {
"uri": "quantumleap:8668/v2/notify",
"accept": "application/json"
}
}
}