Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Solved
Try this:
Table:
LOAD ID,
ATRIB
FROM
[https://community.qlik.com/thread/216855]
(html, codepage is 1252, embedded labels, table is @1)
Where Len(Trim(ID)) > 0;
ResultTable:
LOAD ID,
If(WildMatch(Concat('|' & ATRIB & '|'), '*|55|*', '*|57|*'), 'Fail', 'OK') as Result
Resident Table
Group By ID;
Try this:
Table:
LOAD ID,
ATRIB
FROM
[https://community.qlik.com/thread/216855]
(html, codepage is 1252, embedded labels, table is @1)
Where Len(Trim(ID)) > 0;
ResultTable:
LOAD ID,
If(WildMatch(Concat('|' & ATRIB & '|'), '*|55|*', '*|57|*'), 'Fail', 'OK') as Result
Resident Table
Group By ID;
Hi,
maybe also possible:
tabFailOK:
LOAD Dual(Result,RecNo()-2) as Result
INLINE [
Result
OK
Fail
];
table1:
First 5
LOAD * FROM [https://community.qlik.com/thread/216855] (html, codepage is 1252, embedded labels, table is @1);
tabResult:
LOAD ID,
not Min(ATRIB=55 or ATRIB=57) as Result
Resident table1
Group By ID;
hope this helps
regards
Marco