topic Qualify a data in field in data load editor in App Development

Qualify a data in field in data load editor

_jonah — Wed, 16 Jan 2019 08:34:24 GMT

Hi -

I first unqualify three sets of database. Now, I have to qualify/exclude one database but only for two data in MONTH field. Would you know how to do this in the data load editor? I've been looking for an exact scenario here but didn't see any.

Unqualify *;

Qualify "Month";

would it be possible..

Unqualify *;

Qualify "Month" = 'October','December';

Appreciate any help you could extend. Thank you.

Re: Qualify a data in field in data load editor

Somasundaram — Wed, 16 Jan 2019 09:06:58 GMT

Hi,

We can able to do for column - Qualify/Unqualify. It's not possible to do Qualify "Month" = 'October','December';

Re: Qualify a data in field in data load editor

marcus_sommer — Wed, 16 Jan 2019 09:17:11 GMT

What you want to do is to flag the data and this could be done with something like:

...
if(match("Month", 'October','December'), 0, 1) as MonthFlag
...

and then you could use this flag-field within a listbox or used it as condition in expressions.

- Marcus