Dataflow | Lookup field as one field of alternate key | Null values

[KSven]

Hi lovely community,

Ive built an dataflow with an alternate key for integration. I already know how to use look up fields as part of my key and how to set up the integration key in admin portal.

My key is like this:

Quarterdate

Salesman (Contact Lookup)

Dealer (Account Lookup)

It works if theres content in all 3 fields. But if there's one record with "null" content in one of the lookup fields there's the following error message:

So all fields of alternate keys have to has content and can't be null?!

If its not an required field in table, how I can have an empty integration for it?

BR,

Sven

[KSven]

No ideas...? 😕

[HSheild]

Hi @KSven 

When you are setting the lookup to ‘Null’ what is the input data? Is it blank or are you trying to import a value of Null? Are you able to share a screenshot of your Power Query transformation page?

[KSven]

Hi @HSheild ,

have tested it with a Test table. 

1. Test (alternate Key with 2 normal columns, Name + district )

Name Column (Primary Column of table)      district (text column)

"Test1"                                                             "A-District"

"Test2"                                                             null

--> Data Integration works fine

2. Test (instead of district column as text, its now a lookup to table "district")

District has alternate key of "ID" (Text Column) and "Validtill" (Date Column) -> Works great in other LookUp columns without beeing alternate key

Name Column (Primary Column of table)      district ID (part of lookup column)     Valditill (part of lookup column)

"Test1"                                                             "54"                                                    "2021-01-06"

"Test2"                                                             null                                                     null

--> In this case there will be the error message "lookup value was not found"

Regarding to you question, in my query nothing is blank(), all empty columns are null.

BR,

Sven