Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
How do I do this
Id,job,manager,accepted
1,10,john,yes
2,10,john,yes
3,23,paul,yes
4,45,Jane,yes
Create two expressions or columns in script to
Count where theres accepted yes by Job by job
And
Where theres two jobs accepted like job 10, all other jobs are 1.
Thanks
Hi,
can you tell how you are expecting output based on your table,unable to understand your query.
If columns job,manager are the same and accepted column is populated then count if more than 1.
So I want 1d,1 and 2 be grouped by job and count as 1 because its multiple.
Id 3 and 4 count as 1 because theres just one line.
Outcome
Id,job,manager,accepted,multiple,single
1,10,john,yes,1,
2,10,john,yes,,
3,23,paul,yes,,1
4,45,Jane,yes,,1
Thanks
Thanks a lot