Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
We can able to do for column - Qualify/Unqualify. It's not possible to do Qualify "Month" = 'October','December';
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