Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..........
Can you give a specific example?
Hi,
I think you can go for apply map
just compare field 'c' between the mapping table and the original ,if equals load variable