Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
mahitham
Creator II
Creator II

Flag creating help

Hi,

Can any one please help me on below requirement.

I have a Table like below

Input Table:

Name                   ID     

Trading                 1

Trading                2

Trading                3

Trading               4

Trading                5

Stack holder     1

Stack holder     2

Projects

 

Requirement:

From the above table need to derive a Flag like when each name contains ID's then its 1 else 0. 

The expected output is like below

Name                   ID     

Trading                 1

Stack holder       1

Projects                0

Please help me to get the above output. For each name need to get only one row.

Thanks in advance.

 

 

1 Reply
Vegar
MVP
MVP

You can do  this.

NoConcatenate

Load Distinct 

Name,

IsNum(ID) as ID

Resident  [Input Table];

Drop table [Input Table];