Show results in straight table if a field in different columns is empty "NULL"

[#1]

Dear community,

I've been puzzled with (probably) a simple question.

As the title says, I cannot seem to get data in a straight table if one of the colums has an empty field or NULL.

In the example below I wanted to show all lines if one of the fields is empty (Email, Function or Phone Number).

So i was trying to use the IF function in the expression but I cannot seem to get it working. The formula should look like

IF(Email='nul', OR Function='null', Or Phonenumber='null' then show all records)

Can anyone please assist?

Regards,

Sijmen

[ecolomer]

he you are ...

[ecolomer]

in the attached file you are the solution

[#4]

Hello Marius,

Your solution is helpfull and I understand the context better now. But in my example the table was straight forward, in my case (not the given example) the data are all in different tables.

Therefor when I use your expression my query is empty and shows no fields.

[#5]

Hello Tobias,

I understand how u solved this problem. I want to try this out, but where do I put in the if(isnull( code in the script.

Do i need to put it below the Load line after the data or before it, or even combine it?

I.e.:

Load * INLINE [

Name, Address, Date of Birth, Phonenumber, Email, Function

Data1,data2,data3,data4,data5

if(isnull(Email),'null',Email) as Email,

etc

etc

];

Regards,

Sijmen

[#6]

Thank you, I used your code to fill an extra field in my query which shows when a colomn has an empty field in it.

Very helpfull