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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
sudeepkm_analog
Contributor III
Contributor III

Qlik MS Dynamics Connector returns more columns for certain attributes

Hi All,

We are using Qlik Web connector for MS Dynamics  and I observed that for certain attributes/columns the connector returns more than one columns. Example: I added "createdby" as an attribute under entity "account" then in the result I got four fields.
createdby_Formatted
createdby_Id
createdby_LogicalName
createdby_Name

Now we are working on getting data from MSD to AzureSQL and then from Azure to onprem DB. Surprisingly I found that for the same attribute "createdby" I'm now getting four columns but different names.
createdby
createdby_entitytype
createdbyname
createdbyyominame

and one of the fields (createdbyname) does not have field values. Has anyone ever come across such issue. Please let me know. Thanks.

0 Replies