You’re offline. This is a read only version of the page.
Announcements
32
I am having horrible problems with trying to get a lookup column migrated with the Dataflow Tool.
What my request should be surprisingly quite simple.
I have a table 'call it table 1' and i have a table called table 2 which is am trying to migrate the data.
There is a lookup column in table 2 which is linked to table 1.
and i am trying to get the value of it within a column in table 1.
I have used a key to get the column in dataverse like this - imagine this is table 2
as the column i am looking to get is UWDepartment - and it is linked to a column called LOB in Table 1 and when i try and link the columns together - i get this in DATAFLOW :
so it seems that my key has worked cos the destination is the UWDepartment key as per my above key screenshot .
All i get in the source is :
This gives me loads of errors saying the GUID does not exist but it does..
""avg_CarrierLOB@odata.bind"": ""/avg_uwdepartmentses(avg_uwdepartment='04f546cb-224e-ed11-bba2-0022481b5772')""
}","{""error"":{""code"":""0x80060891"",""message"":""A record with the specified key values does not exist in avg_uwdepartments entity""}}"
I am passed banging my head against the wall now with this... anyone can help would be much appreciated.
I have fixed this by using this column instead :
so i found the one below which had name on the end and it seemed to have worked... This should be easier...
Share
Report
All responses (
Answers (
