Create straight table with a subset of values

[#1]

Dear all,

I have a dataset that can be reproduced like this:

LOAD * INLINE [
TASK_OWNER, CODE
Henk, 1
-, 2
Piet, 1
];

Now I would like to create a straight table that only show the records where the TASK_OWNER has a "-" value. So I add a straight table with a calculated dimension that looks like this:

=only({<[TASK_OWNER]={'-'}>}TASK_OWNER)

[Anonymous]

What issue you are facing?

[tresesco]

Try taking CODE as dimension and then the expression as expression.

[miguelbraga · Accepted solution]

Hey there,

Why not just simply do like this:

LOAD * INLINE [
TASK_OWNER, CODE
Henk, 1
-, 2
Piet, 1
]

WHERE TASK_OWNER = '-'
;

Then just invoke the dimension TASK_OWNER as it is 

Hope this solve your problem...

Regards,

MB