Hi all,
Based on the following (see also attached .qvw file) I want to create a pivot/table that shows
Name, Yes / No
All names should only be shown once, and all names that have the Value 3 as a possible result should show Yes, the rest should show No.
I.e I want this result:
Arne, Yes
Harald, No
Jens,No
Olav, Yes
Any suggestions on how to solve this?
(I can solve this during scripting load, but I want to solve it without doing that).
Thanks,
Olav
--------------------------------------------
Table1:
LOAD * INLINE [
KeyField,Name
1,'Olav'
2,'Harald'
3,'Arne'
4,'Jens'
];
Table2:
LOAD * INLINE [
KeyField,Value
1,1
2,1
3,1
4,1
1,2
2,2
3,2
4,2
1,3
2,4
3,3
4,4
1,5
2,5
3,5
4,5
];
Dim: Name
Exp: If(Max(If(Value=3,1,0))=1, 'Yes', 'No')
PFA
Thanks a lot for a very quick and correct answer!
Olav