Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You can do this.
NoConcatenate
Load Distinct
Name,
IsNum(ID) as ID
Resident [Input Table];
Drop table [Input Table];