Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am stuck at some point in development process and would need you help and suggestions.
My excel file contains data in the format as specified below.
Name | Prod/Non Prod | Activity |
Amit | Prod | Call |
Amit | Prod | Meeting |
Amit | Prod | Test |
Amit | Non Prod | Break |
Monika | Prod | Call |
Monika | Non Prod | Break |
Monika | Non Prod | Games |
Monika | Non Prod | check mail |
Priyanka | Prod | QA |
Priyanka | Prod | Call |
Priyanka | Non Prod | Break |
Priyanka | Non Prod | check mail |
Sarvesh | Prod | Test |
Sarvesh | Prod | Meeting |
Sarvesh | Prod | QA |
Sarvesh | Non Prod | Break |
Sumit | Prod | Call |
Sumit | Prod | Test |
Sumit | Prod | Meeting |
Sumit | Non Prod | Break |
Vikas | Non Prod | Break |
Vikas | Prod | QA |
Vikas | Non Prod | check mail |
Vikas | Non Prod | Games |
I need to load data on following conditions only
Where
Activity <> 'Break'
And (Match(Name, 'Priyanka', 'Vikas') = 0 Or ([Prod/Non Prod] <> 'Non Prod' And Activity <> 'QA'))
Try this:
Table:
LOAD Name,
[Prod/Non Prod],
Activity
FROM
[https://community.qlik.com/thread/204640]
(html, codepage is 1252, embedded labels, table is @1)
Where Activity <> 'Break' and
not(Match(Name, 'Priyanka', 'Vikas') and ([Prod/Non Prod] = 'Non Prod' or Activity = 'QA'));
Or, if its slightly clearer, the functionally equivalent:
Where
Activity <> 'Break'
Not (Match(Name, 'Priyanka', 'Vikas') And ([Prod/Non Prod] = 'Non Prod' Or Activity = 'QA'))
Hi Priyanka,
Where
Activity <> 'Break' and (
Not(Match(Name, 'Priyanka', 'Vikas')
Or
(Match(Name, 'Priyanka','Vikas') And [Prod/Non Prod] <> 'Non Prod' And Activity <> 'QA')
);
Regards