topic How do I identify different types of Documents ? in QlikView

How do I identify different types of Documents ?

ngulliver — Thu, 03 May 2012 11:26:19 GMT

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

kaushiknsolanki — Thu, 03 May 2012 12:39:14 GMT

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

ngulliver — Thu, 03 May 2012 13:04:33 GMT

Hi, Kaushik.

Thanks for your help. Very useful.

Regards,

Neil