How to create dual if flag statement

Thu, 06 Apr 2017 15:05:59 GMT

Hello, I'm trying to create a compliance flag to add to this current load. this is what i tried, but when i do so, the dates are no longer showing.

LOAD *,

If(Match([Flag],'0-14 days')> 0,'Compliant',

If(Match([Flag],'15-30 days',[Severity] <> 'Critical')>0,'Compliant','Non-Compliant')) as Compliance_Flag

AND

// If(Flag = '0-14 days', Dual('Compliant', 1),

// If(Flag = '15-30 days', Severity <> 'Critical', Dual('Compliant', 2),

// if(Flag = '15-30 days', Severity <> 'Critical', 'Compliant') as Compliance_Flag

Initial load script:

TestCombined:

LOAD Flag,

Severity,

IP_Address,

First_Discovered,

Plugin_name,

Repository,

MonthYear;

FROM $(vQVDlocation)CVATest.qvd(qvd)

Where not WildMatch(Severity, 'Medium*', 'Low*', '*Info*');

CONCATENATE(TestCombined)

LOAD

Flag,

Severity,

IP_Address,

First_Discovered,

Plugin_name,

Repository,

Closed_Mitigated_On,

MonthYear,

if(Flag = '0-14 days', 'Compliant'),

if(Flag = '15-30 days', Severity <> 'Critical', 'Compliant') as Compliance_Flag

FROM $(vQVDlocation)CVAClosed.qvd(qvd)

Where not WildMatch(Severity, 'Medium*', 'Low*', '*Info*');

//Create the QVD File

STORE TestCombined into $(vQVDlocation)CVACombined.qvd (qvd);

DROP TABLE TestCombined;

Re: How to create dual if flag statement

Peter_Cammaert — Thu, 06 Apr 2017 15:12:17 GMT

As we have no clue which dates you're talking about, would it be possible to post an example document with some data that shows unwanted behavior?