I would have replaced your first load with an preceding load on the E1P-table. Then do the second join on the E1P-table. Like this:
LOAD [SingleAssignment],[SingleAssignment]&[DollarTest] as ConcatField ;
Field2, SingleAssignment, DollarTest,
Left JOIN (E1P) LOAD [SingleAssignment], Count(DISTINCT [ConcatField]) as ConcatFieldCount,
If(Count(DISTINCT [ConcatField]) = 1,'SingleAssignmentFlag',
If(Count(DISTINCT [ConcatField]) > 1,'QtyDiffFlag')) as Flag
GROUP BY [SingleAssignment];
I hope this can be of any help. Good luck with finding your solution.
#OnVacation #BetweenJobs. Please ekskuse my Norglish and Swenglish typos.