Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Updating a column of QVD

Hi All,

              I have a QVD  which has 3 columns A,B,C. I load a table from database which has the same colums of QVD. Now i compare column C from QVD with column C of loaded table. After comparing if the loaded table has a new value then i want to overwrite that value in the QVD at the same place. Dont want to add or delete any new rows or columns. Till comparision everything is working fine. The value to be replaced is stored in a variable . I dont understand how to copy that new value in place of old value. Its like i have reached the destination with my letter but i dont know how to stick it there in simple words. can something like peek or fieldvalue work??? Or plz suggest me something else..........

2 Replies
jason_michaelid
Honored Contributor II

Re: Updating a column of QVD

Can you give a specific example?

Not applicable

Re: Updating a column of QVD

Hi,

I think you can go for apply map

just compare field 'c' between the mapping table and the original ,if equals load variable

Community Browser