It is possible to return value above current row if current row is blank or Null.
There are 3 function that we can use here (potentially more).
These functions are
Try these script line
,IF(LEN(BlankFieldName)=0,Peek('BlankFieldName'),BlankFieldName) AS Whatever
If this doesn't work then substitute LEN() with ISNULL(). As in
,IF(ISNULL(IsNullFieldName),Peek('IsNullFieldName'),IsNullFieldName) AS Whatever
Hope this help
I followed your format:
If(ISNull([Agent Name]),UPPER(Peek('Agent Name')),UPPER([Agent Name])) As CSR_NAME
but it is not loading CSR_NAME correctly. For some reason it loads correctly if I don't rename the field and just load it ias [Agent Name]. But trying to rename has it load the same way as before. Any thoughts?
This is because Peek looks at the output of the last line.
Since Agent Name is not set again it will not exists for any other line than the first.
The fix is to either Peek('Agent Name') and not rename the field or Peek('CSR_Name') and rename the field to CSR_NAME
If(ISNull([Agent Name]),UPPER(Peek('CSR_NAME')),UPPER([Agent Name])) As CSR_NAME