Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
rupaliqlik
Contributor

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
Contributor III

Re: Remove excel files from column

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

Re: Remove excel files from column

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'
;
Plees ekskuse my Swenglish and or Norweglish spelling misstakes