mariozubieta
Contributor III
2017-11-16
03:14 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Update Rows on Table
Hello,
I'm currently trying to load information from a file, and replace the updated values on my qvd. For example:
Any ones has ideas on how to do this. Both current qvd and update table fields are named the same.
thanks
- Tags:
- update rows
1,629 Views
1 Solution
Accepted Solutions
Anonymous
Not applicable
2017-11-16
03:51 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Load
ID,
Id as ExcludedID
from UpdateTable;
concatenate
Load
*
from ResidentQVDFile
where not exists(ExcludedID,ID);
Drop field ExcludedID;
1,500 Views
3 Replies
Anonymous
Not applicable
2017-11-16
03:39 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Load
ID
from UpdateTable;
concatenate
Load
*
from QVDFile
where not exists(ID);
1,500 Views
mariozubieta
Contributor III
2017-11-16
03:45 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
is there a way to do it with the qvd loaded previously, without having to store it and load it.
thanks for the reponse.
1,500 Views
Anonymous
Not applicable
2017-11-16
03:51 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Load
ID,
Id as ExcludedID
from UpdateTable;
concatenate
Load
*
from ResidentQVDFile
where not exists(ExcludedID,ID);
Drop field ExcludedID;
1,501 Views