topic Re: Create a flag in App Development

Create a flag

paulwalker — Wed, 03 May 2023 05:18:25 GMT

Hi Community,

below is my table

Load * Inline [
Name, Software, Status
Paul, Qlikview, Active
Paul, Qlik Sense, Active
Akram, Qlik Sense, Active
Edwerd, Spotfire, Active
Edwerd, Spotfire, In-Active
Ryan, Splunk, In-Active
Ryan, Tableau, In-Active
];
If user doesn't have active status, we have to tag close else Active. (I'm expecting output column like below)

Name	Software	Status	Output
Paul	Qlikview	Active	Active
Paul	Qlik Sense	Active	Active
Akram	Qlik Sense	Active	Active
Edwerd	Spotfire	Active	Active
Edwerd	Spotfire	In-Active	Active
Ryan	Splunk	In-Active	Closed
Ryan	Tableau	In-Active	Closed

Thanks in Advance!

Re: Create a flag

Prem0212 — Wed, 03 May 2023 05:28:17 GMT

T think this script will work for you.

Emp_Details:

Load *,
If(Status= 'Active', 'Active', 'Closed') as Output
Inline
[

Name, Software, Status
Paul, Qlikview, Active
Paul, Qlik Sense, Active
Akram, Qlik Sense, Active
Edwerd, Spotfire, Active
Edwerd, Spotfire, In-Active
Ryan, Splunk, In-Active
Ryan, Tableau, In-Active

];

Re: Create a flag

paulwalker — Wed, 03 May 2023 06:12:01 GMT

Thanks for quick response,

this will not work. (It will give all in-Active to Closed and this will work only for Status column)

but my scenario is I have to group on Name level, let say Ryan doesn't have Active - it should tag Closed

Another Example: Edwerd has Active and In-Active - it should tag to Active for both records

Re: Create a flag

Chanty4u — Wed, 03 May 2023 06:27:34 GMT

Try this

LOAD

Name,

Software,

Status,

If(Sum(If(Status='Active',1,0))>0, 'Active', 'Closed') AS Output

RESIDENT

[YourTable]

GROUP BY

Name, S

oftware;

Re: Create a flag

paulwalker — Wed, 03 May 2023 08:25:49 GMT

I have tried with changed data

ABC:
LOAD * INLINE[
Name, Software, Status
Paul, Qlikview, Active
Paul, Qlik Sense, Active
Akram ,Qlik Sense, Active
Edwerd ,Spotfire, Active
Edwerd ,ABC, In-Active
Ryan, Splunk, In-Active
Ryan, Tableau ,In-Active
];

LOAD Name,
Software,
Status, If(Sum(If(Status='Active',1,0))>0, 'Active', 'Closed') AS Output
Resident ABC
GROUP BY
Name, Software, Status;

drop table ABC;
exit script;

Edwerd should be Active

Re: Create a flag

Kushal_Chawda — Wed, 03 May 2023 08:42:43 GMT

@paulwalker try below

Data: Load * Inline [ Name, Software, Status Paul, Qlikview, Active Paul, Qlik Sense, Active Akram, Qlik Sense, Active Edwerd, Spotfire, Active Edwerd, Spotfire, In-Active Ryan, Splunk, In-Active Ryan, Tableau, In-Active ]; Left Join(Data) Load distinct Name, Status as Status_new Resident Data where Status='Active'; Final: NoConcatenate LOAD *, if(isnull(Status_new),'Closed',Status_new) as Status_Final Resident Data; Drop Table Data; Drop Field Status_new;

Re: Create a flag

Sabrina_V — Wed, 03 May 2023 08:52:15 GMT

Try this :

DATA:
Load * Inline [
Name, Software, Status
Paul, Qlikview,Active
Paul, Qlik Sense,Active
Akram, Qlik Sense,Active
Edwerd, Spotfire,Active
Edwerd, Spotfire,In-Active
Ryan, Splunk,In-Active
Ryan, Tableau,In-Active
];

TEST:
MAPPING LOAD DISTINCT
Name,
Status as FlagActive
RESIDENT
DATA
WHERE
Status ='Active';

NoConcatenate
FINAL:
LOAD
*,
ApplyMap('TEST',Name,'Closed') as Output
RESIDENT
DATA;

DROP TABLE DATA;

And the result is :

Re: Create a flag

maxgro — Wed, 03 May 2023 09:13:40 GMT

left join (DATA) LOAD
Name,
if(MinString(Status)='Active', 'Active', 'Closed') as Output
resident DATA
group by Name;