Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Maxime_Lenglet
Contributor
Contributor

MDM Query Language: how to alias Types in $explicitprojection$?

In our company we have a Talend MDM Enterprise Edition server.

From the homepage of the TAC, I can see version is: 7.1.1.20181026_1147-

I'm in charge of querying data from this system. Disclaimer: I'm not part of our team working with the Talend server.

So I use the MDM Query Language as described in this online doc: https://help.talend.com/reader/OExHeKAk2NLlFKnNAXdI1A/ef~ulFtrHdc5ut5XIpp5IA

When I query like this:

{

 "select": {

  "from": [

   "SomeType"

  ]

}

}

I get something like this:

[

 {

  "sometype": {

   "idsometype": "1",

   "labelsometype": "Label # 1"

  }

 },

 {

  "sometype": {

   "idsometype": "2",

   "labelsometype": "Label # 2"

  }

 }

]

I saw there is a way to alias fields, e.g.

{

 "select": {

  "from": [

   "SomeType"

  ],

  "fields": [

   {

    "alias": [

     {

      "name": "id"

     },

     {

      "field": "SomeType/IdSomeType"

     }

    ]

   },

   {

    "alias": [

     {

      "name": "label"

     },

     {

      "field": "SomeType/LabelSomeType"

     }

    ]

   }

  ]

}

}

but then I get this:

[

 {

  "$explicitprojection$": {

   "id": "1",

   "label": "Label # 1"

  }

 },

 {

  "$explicitprojection$": {

   "id": "2",

   "label": "Label # 2"

  }

 }

]

HOW do I alias the "$explicitprojection$"???

Labels (3)
0 Replies