How do i update multiple Columns of data with where clause

[Keitaru]

Have Data set one in qvd other in excel

Data:
Load * FROM [$(vQVDFolder)/RDO.QVD](QVD);

Update:
LOAD
"Order Id",
"Trade Date",
"Actual Settlement Date",
Status,
"Correspondence Mode",
"Repair Indicator",
"Incoming Error Tag",
"Incoming_Problem Description"
FROM [$(vQVDFolder)/Trade Data.xlsx]
(ooxml, embedded labels, table is Sample);

Need to update the above columns into current data set where "Repair Indicator" = Yes

Anyone know how i can do this? I know I may need to do left join or something.

[sidhiq91]

@Keitaru  I could not understand the issue. Could you please elaborate or provide some samples with the expected output?

[PrashantSangle]

what is your common Key field between these 2 table.

Try below 

Data:
Load * FROM [$(vQVDFolder)/RDO.QVD](QVD);

Left Join

Update:
LOAD

"Order Id",

"Trade Date",
"Actual Settlement Date",
Status,
"Correspondence Mode",
"Repair Indicator",
"Incoming Error Tag",
"Incoming_Problem Description"
FROM [$(vQVDFolder)/Trade Data.xlsx]
(ooxml, embedded labels, table is Sample)

Where "Repair Indicator" = 'Yes'

;

[Vegar]

How does the first qvd data look like ? Is it structured identical as your Excel? And you want to update the rows containing "Repair Indicator" = 'Yes'?

Does the update contain the full new record or just parts that needs to be added to the Data?

It would be good if you have us a sample example.

[Jebrezov]

I’m interested in suggestions people give. My guess would be if it is as @Vegar mentions and your data sets are the same columns and you are trying to simply modify rows in the existing data, you will need to concatenation the 2 sources together and then remove the original now duplicate rows. You’ll likely need to add a new field to identify what data is from the new set vs old to achieve this.