Create a flag field in script

[#1]

I've loaded about 2million rows with sales data into my qvw model. There are about 100 customers that need to be flagged for possible exclusion from the total. To make this exclusion optional, I'd like to create a new field flagging the 100 customers with a 'X' and all other entries 'Y'; this would allow a simple list box click to either include or exclude the 100.

Is this possible to do in the load script?

Thank you in advance.

[rwunderlich · Accepted solution]

I'm sure there is more than one way to answer this question. But a solution that comes to mind is to use a Map that assigns 'Y' to the excluded group and 'N' to all others. See attached example.

-Rob

[#3]

Thank you. This works exactly.