Creating flag to identify primary dataset

r_wroblewski — Wed, 25 Feb 2015 11:53:43 GMT

Dear Community

I try to create a flag to identify the primary data set in the script.

I have a field called datatype where 1,2 or 3 is possible for same date.

Numbers can be interpreted as 1=received, 2=expected, 3=planned.

Please see attached qvw and excel file as example.

What I try to achieve: (same date)

1) datatype 1,2 and 3 1 flagged as primary

2) datatype 1 and 3 1 flagged as primary

3) datatype 2 and 3 2 flagged as primary

4) datatype only 3 3 flagged as primary

I also need all data sets in my application for comparison.

I tried different approaches like FirstSortedValue but couldn't achieved what I need.

Most likely I just missed something simple but if anyone has any ideas I would be very grateful.

Best regards,

Ronny

Re: Creating flag to identify primary dataset

r_wroblewski — Thu, 26 Feb 2015 08:47:14 GMT

Dear Community,

I could solved this issue by myself after reading following thread:

and will mark this thread as answered.

Best regards,

Ronny