Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Only importing records where reords exists in one column

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.

NameE-mailNotes
Jon DoeJon@Hotmail.comCall on Monday
Susan SurrandonSusan@Gmail.comWant to invest large in BI sollutions
Sly StaloneCall on Tuesday
Mr WanndameWanndame@hotmail.comIs 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.

1 Solution

Accepted Solutions
Not applicable

Re: Only importing records where reords exists in one column

try with

"(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

where Len([E-postadress])>0;"

2 Replies
Not applicable

Re: Only importing records where reords exists in one column

try with

"(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

where Len([E-postadress])>0;"

Not applicable

Re: Only importing records where reords exists in one column

Thanks, the answer works fine.