Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
rupaliqlik
Partner - Creator
Partner - Creator

Remove excel files from column

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

 

2 Replies
Claudiu_Anghelescu
Specialist
Specialist

WHERE Not Match(Path, '*xlsx*')
To help community find solutions, please don't forget to mark as correct.
Vegar
MVP
MVP

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
]
Where right(Path,5) <> '.xlsx'
;