Can some one help me here how can we write in script for below scenario
I have one Project ID for that we will have multiple Subtasks , out of that if one subtask is bad i want to exclude complete Project. how can i do it.
in below example one project has multiple Subtasks out of that if i have one Bad subtask at least (ExclusionProjectFinalFlag='1') then i want to exclude that Project completely from my report .
how ca i write in script, can some one help me here.
Solved! Go to Solution.
Same i wrote , but it is not working.
1 project has multiple subtask so if i write like above its just excludes only that subtasks which is ExclusionProjectFinalFlag='1' still that Project appears in the report.
my point is for project if one subtask has ExclusionProjectFinalFlag='1' that project itself should be excluded from the report.
Ok Please try this:
from<Table Name > where ExclusionProjectFinalFlag='1'(quotes only if character);
Load Proj_id as ProjectID,
Other Col Names,,,,,
From <Table Name >
where not exists(Proj_id,ProjectID);
You can try below.
from your table;
from your table
where not exists(ProjectID) ;
Drop Table A;
Note : Please use the correct fields name.