Concatenate comment

bobbydave — Sat, 16 Nov 2024 04:12:10 GMT

I have an weekly excel file which is an NPrinting output. On this there is a [Action Status] and Comments section.

This report is a Vulnerability report which has a %Vulnerability, a V_Date with data and the [Action Status] and Comments rows (the first time around) will be blank. The user puts in their comments and the excel file is then reloaded.

Excel concatenated with QVD (QVD would be the output of the original NPrinting report. So in effect, I am just updating the [Action Status] and Comments to the %Vulnerabilities.

So the logic would be

if %Vulnerabilities match, use the %Vulnerabilities that have a comment and action status.

If blank when loading and there is a Comment in the QVD, use, the %Vulnerabilities with the Comment

Commentary:
LOAD %Vulnerability, 
     [Action Status], 
     Comment,
     [Vulnerability Date]
FROM
[$(vQVDs)\Report.qvd](qvd) where not Exists (%Vulnerability);


Concatenate

LOAD %Vulnerability,  
     [Action Status], 
     Comment,
     Date(Date#(left(SubField(FileName(), ' ', -1),10), 'YYYY-MM-DD'), 'DD/MM/YYYY') AS [Vulnerability Date]  
FROM
[$(vReport)\Vulnerability_Tracker *.xlsx]
(ooxml, embedded labels, table is Vulnerability_Tracker) Where len(Comment) >0;//  Date(Date(Date#(left(SubField(FileName(), ' ', -1),10), 'YYYY-MM-DD'), 'DD/MM/YYYY'),-21) > $(Last_Updated_Date);


Store Commentary into $(vQVDs)\Report.qvd(qvd);

Re: Concatenate comment

bobbydave — Wed, 13 Mar 2019 08:36:58 GMT

Anyone … any help with this?

Re: Concatenate comment

Brett_Bleess — Wed, 20 Mar 2019 19:33:19 GMT

I believe the reason nobody is responding is the same confusion I have, not sure what you are asking in this case, can you clarify what it is you need us to review, as it is not apparent to me, so I am pretty sure others are likely confused as well.

Regards,
Brett

topic Re: Concatenate comment in QlikView

Concatenate comment

Re: Concatenate comment

Re: Concatenate comment