estrazione record con campo a null

[warrentk80]

Goodmorning everyone,

I need to display in a table-like graph, only the records that have the lD empty field (null) You would know someone show me how to do? I entered the dimensions that m affect expression that I use to filter records with null lD?

Thank you Andrew

[andrespa]

Hi Andrea, you could put something like this as a dimension:

=IF(IsNull(ID)=-1, ID)

Hope it helps,

Andrés

[warrentk80]

Hello Andrea, thanks for your kind and polite response.
I tried to insert as a dimension calculated the formula that you have shown me,
but I keep all records 😞

[andrespa]

Hi Andrea, no worries. Then maybe in the script you could put something like this:

Table:

Load *

From [your_path]

WHERE isNull(ID)=-1;

And then it should give you just the ID null values

Hope it helps,

Andrés