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.