Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
gfisch13
Creator II
Creator II

Add a blank field

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

Labels (1)
12 Replies
gfisch13
Creator II
Creator II
Author

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.....

Kushal_Chawda

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

gfisch13
Creator II
Creator II
Author

Thanks Kush - appreciate the help, exactly what I was looking for!