Concatenate and use another outputted column

[bobbydave]

So I have an excel sheet(s). Lets use one for this test.

Then I have a QVD of data (both headings all the same except for the last two columns).

The excel file will have a Comments column with detail.

The QVD will have a Comments column but will be empty/blank.

I have a %Vulnerability key in both.

Load * from excel

Concatenate

Load * from qvd

Now I need to concatenate the two files and if %Vulnerability in each match, I will take the Comment with the text from the excel file and remove the %Vulnerability in the QVD.

Any ideas on where to start guys?

[rubenmarin · Accepted solution]

Hi, you can use Exists() to load rows from qvd that has not been loaded in excel:
Load * from excel
Concatenate
Load * from qvd where not exists(%Vulnerability)