Forum Discussion

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
2 years ago

TMSL equivalent in XMLA

Does XMLA has an equivalent of TMSL's createOrReplace?   I tried with Alter Element but it did not work.   bcdobbs  GilbertQ 
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

seems to be the same syntax.

 

{
  "createOrReplace": {
    "object": {
      "database": "Opportunity Field History",
      "table": "Opportunities",
      "partition": "2014"
    },
    "partition": {
      "name": "2014",
      "mode": "import",
      "source": {
        "type": "policyRange",
        "start": "2014-01-01T00:00:00",
        "end": "2015-01-01T00:00:00",
        "granularity": "year"
      }
    }
  }
}