Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to understand if QV will support placing a field in a blank field in a table, thinking this needs to be done in the load script.
Would it be possible to turn that new field into some type of user input field to mark a record as reviewed?
Ideally - I'm trying to create a workpaper. Just trying to understand if this is even possible or I'm spinning my wheels. Thanks, George
This worked perfectly, thank you.
But now I have to adjust something since every record is being shown in my table box. I'd rather have one record per ID. How could I accomplish that?
see attached.....
You can create distinct recorof employee ID by creating new field
inputfield Reviewed;
Data:
load *,
Employee ID
FROM Source;
DistinctEmployee:
load distinct Employee ID,
Employee ID as Distinct_Employee,
'' as Reviewed
resident Data;
Now use Distinct_Employee field in tablebox
Thanks Kush - appreciate the help, exactly what I was looking for!