Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want to join notes into a contact table using the left join function. I have e-mailaddress as the key and I am adding notes about the contact into an existing table. The problem is that in the outlook extract sometimes there are notes about a person but the e-mail address is missing. What happens then is the that note is being added onto all contacts in the data model.
Name | Notes | |
Jon Doe | Jon@Hotmail.com | Call on Monday |
Susan Surrandon | Susan@Gmail.com | Want to invest large in BI sollutions |
Sly Stalone | Call on Tuesday | |
Mr Wanndame | Wanndame@hotmail.com | Is getting old |
I have added the table as an example. What will happen is that Call on Tuesday will be added onto all contacts in the contact list. I have tried to use the where exists function but it does not make a difference in the import.
"(txt, codepage is 1252, embedded labels, delimiter is ',', msq)
where Exists([E-postadress]);"
Happy for any help.
try with
"(txt, codepage is 1252, embedded labels, delimiter is ',', msq)
where Len([E-postadress])>0;"
try with
"(txt, codepage is 1252, embedded labels, delimiter is ',', msq)
where Len([E-postadress])>0;"
Thanks, the answer works fine.