Hi, I didn´t follow you. Maybe I didn´t describe the issue correct.
I will try again.
I have two files with different information which I would like to join into one.
FROM $(vPathQvdRaw)\Item.qvd (qvd);
SQL SELECT *
item_number and service_code is a item number coming from different tables/sources and named differently. I would like to include the service_code into the item table.
How should I write it into the script?
If item_number in the qvd file and service_code in the SQL database are the same field but with different names, then just renaming the field and concatenating tables will work, as suggested above
Item:LOAD item_number, item_descriptionFROM $(vPathQvdRaw)\Item.qvd (qvd);CONCATENATE LOAD "service_code" as item_number, "service_description" as item_description;SQL SELECT *FROM swedb.dbo.service;
Now "Item" table will have all the information so you can STORE it in one file.
Hope this helps.