topic Re: Remove excel files from column in QlikView

Remove excel files from column

rupaliqlik — Wed, 03 Apr 2019 09:16:01 GMT

Hi All,

I have on e column which contain QVW application with path ,qvd with path and excel files with path.I want to remove excel files from column .Can you help me on this?

load * inline
[
Path
\\pwil0699qvfs01\qlikview\bd2 to bd1 1qtc product ref.xlsx
\\pwil0699qvfs01\qlikview\\contract data\bd2 to bd1 tradeorg xref.xlsx
\\pwil0699qvfs01\qlikview\\bd_oasis\mps\mka product xref.xlsx
\\pwil0699qvfs01\qlikview\MDS_Dashboard.qvw
\\pwil0699qvfs01\qlikview\BDI.qvd
\\pwil0699qvfs01\qlikview\A&P.qvw

];

Remove xlsx files from column

Re: Remove excel files from column

Claudiu_Anghelescu — Wed, 03 Apr 2019 16:27:29 GMT

WHERE Not Match(Path, '*xlsx*')

Re: Remove excel files from column

Vegar — Wed, 03 Apr 2019 17:12:56 GMT