Merging two flags into one

karan_kn — Wed, 25 Nov 2020 16:16:04 GMT

How to merge two Flags into one. need to combine all values.

Create common flag (Flag1 & Flag2)
Common_Flag - Test1, Test2, Test3 Test4,

NoConcatenate
T1:
LOAD *,

IF(MonthDiff >= 1 AND MonthDiff <= 36, 'Test1',
IF(MonthDiff >=37 AND MonthDiff <= 60, 'Test2','Test3')) AS Flag1;

LOAD *,
IF(ISNULL(Max_DT) = -1, 'Null', ((year(DateKY)*12)+month(DateKY)) - (((year(Max_DT)*12)+ month(Max_DT)))) AS MonthDiff

Resident Temp;
DROP Table Temp;

NoConcatenate
T2:
LOAD
*,
If(WildMatch(Flag1,'Test1'),
If(Flag1,'Test2','Test1'),'Test4') as Flag2

Resident T1;

Re: Merging two flags into one

Brett_Bleess — Wed, 28 Aug 2019 18:25:23 GMT

Karan, consider attaching your app or a sample, these types of posts generally get better responses when doing that. This will kick things back up the list too, so someone may see it fresh and leave you something, but if you can attach an app, that should help.

Regards,
Brett

topic Re: Merging two flags into one in QlikView

Merging two flags into one

Re: Merging two flags into one