Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
cancel
Showing results for 
Search instead for 
Did you mean: 
ngulliver
Partner - Specialist III
Partner - Specialist III

How do I identify different types of Documents ?

Hi,

I have a field containing file names.

I need to be able to create a field that identifies the suffix (i.e. .xlsx, .doc) and defines what software is being used (i.e. Excel, Word, etc).

How do I do this ? (I think I can use an ApplyMap to cross reference the suffix with the software)

Sample data:


Highres.pdf
CV.pdf
Viewer.pdf
Feb 11 Stats.xlsx
March 11 Stats.xlsx
0085_001 .pdf
Microsoft Word - Wednesday's Deli  sandwich.doc
Microsoft Word - 12th-16th.doc
Microsoft Word - REHEATING  INSTRUCTIONS.doc
Microsoft Word - The Friday Night  Takeaway 24th Feb.doc
Microsoft Word - Monday- Friday Menu.doc
C:\Users\sandwichorder.xps
Hospitality Rota.xlsx
Contacts
Telephone Numbers

Many thanks,

Neil

1 Solution

Accepted Solutions
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

   First thing you can extract the extension from the file name like this.

   subfield(filename,'.',2) as Extension

   and then you can create a new table which will have fields as Extension and Software used.

   Now you can link this two table with extension field.

   Hope this will help

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

2 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

   First thing you can extract the extension from the file name like this.

   subfield(filename,'.',2) as Extension

   and then you can create a new table which will have fields as Extension and Software used.

   Now you can link this two table with extension field.

   Hope this will help

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
ngulliver
Partner - Specialist III
Partner - Specialist III
Author

Hi, Kaushik.

Thanks for your help. Very useful.

Regards,

Neil