Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
bobbydave
Contributor III

Concatenate and use another outputted column

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?

 

 

Labels (4)
1 Solution

Accepted Solutions

Re: Concatenate and use another outputted column

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)
1 Reply

Re: Concatenate and use another outputted column

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)