Solved: How do I identify different types of Documents ? - Qlik Community

ngulliver · ‎2012-05-03

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 · ‎2012-05-03

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!

kaushiknsolanki · ‎2012-05-03

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 · ‎2012-05-03

Hi, Kaushik.

Thanks for your help. Very useful.

Regards,

Neil