I have attempted adding an addition load field of "Count(@1) as TX_COUNT and adding the group by statement after the loaction of the file, but have not had much luck. Does anyone know what I need to do and what the proper script should be to get the Rev-Trac# counts?
So that I understand... One would use the LEFT JOIN to ADD another column to an existing table. Then when instructing the join where it is getting it's data from I have to use the RESIDENT call to call the already exisitng table. Does that sound about right???