Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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