I have this import where the CSV file has the data for this entity and the last column is the data to another entity that is linked a 1:N
so lets say the CSV is
Entity A | Entity B
column 1, Column2 | Column 3
john , Smith | Programmer
And I map it like
Source | Destination
1 (John) | A1
2 (Smith) | A2
3 (programmer) | B3 (option set)
As it is for column 3, it is not creating a link when I import it
Apparently there was a option set on that form but now its being replaces with a Grid
So Entity A has a grid with info of related records from entity B rather than a look up option set.
Is there a way to link it through import? does the value for column 3 need to be its ID rather that the value?
Please go through following post.
Hope this helps. If you get answer of your question, please mark the response as an answer and vote as helpful !