Skip to main content

Notifications

Microsoft Dynamics CRM forum
Answered

How can I import data into a new entity and associate it with an existing entity? CDS doesnt allow to make a join on a column.

Posted on by 95

I have an entity that I imported using a data flow from a SQL view. This entity is a primary table to two additional tables - how can I import the other two tables and associate it with this primary table (1:Many). CDS/Dataverse doesnt allow to join on coloumn like SQL.

  • meelamri Profile Picture
    meelamri 13,198 User Group Leader on at
    RE: How can I import data into a new entity and associate it with an existing entity? CDS doesnt allow to make a join on a column.

    You are welcome partner :)

  • mykedeabreu Profile Picture
    mykedeabreu 95 on at
    RE: How can I import data into a new entity and associate it with an existing entity? CDS doesnt allow to make a join on a column.

    Thanks for always answering my questions Mehdi!

  • Verified answer
    meelamri Profile Picture
    meelamri 13,198 User Group Leader on at
    RE: How can I import data into a new entity and associate it with an existing entity? CDS doesnt allow to make a join on a column.

    Hi,

    You need to create some Alternate Keys. Please check out this blog, it might help:

    crmkeeper.com/.../

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,469 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans