Flag creating help

[mahitham]

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.

[Vegar]

You can do  this.

NoConcatenate

Load Distinct 

Name,

IsNum(ID) as ID

Resident  [Input Table];

Drop table [Input Table];