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.

(0) Share

Report

Posted on by mykedeabreu

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.

All responses (3)

Answers (1)

meelamri 13,204 User Group Leader on at

Like (0)

Report

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 95 on at

Like (1)

Report

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 13,204 User Group Leader on at

Like (0)

Report

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/.../