Loading data

[prabhas277]

Hi To All,

Please find the below Attached file. now my question is in that file some data is there if i load that file in qlikview then in the front end listbox are Source,  Date,Time, Type, Message    In message list box i want only Xlsx files.how i can get that data ?

[simsondevadoss]

Can you be more specific ? Since i don't find the xlsx files

[prabhas277]

HI Simson,

Please go through the bottom of the database file then u can find the xlsx files.

[prabhas277]

Hi Simson,

Please go through the bottom of the database file then u can find the xlsx files.

[#5]

please see file attached.

Regards

RL

[simsondevadoss]

sorry i have missed that.

use the expression in the list box : =if(WildMatch(Message,'*.xlsx'),Message)

[#7]

Use below as LIst box expression:

=SubField(if(wildmatch(Message,'*xlsx')=1, Message,null()),'\',6)

Hope this was helpful or correct.

Thanks,

Angad