Concatenate comment

[bobbydave]

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);

[bobbydave]

Anyone … any help with this?

[Brett_Bleess]

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