Problem in wildmatch and find data

[balrammahato204]

Hi all,

Please help me out

i have scenario like this i have one log file of each ID in the log file Column .'Assignee' is one of the field which is available in the log file. i want the first "Assignee" filed corresponding date when "Assignee" field has some name.

Note:-In the log file may be various kind of information is available and index is not fixed in all the time for the 'Assignee' field.It will be change when new entry will come in the log file.

ID	Log File	Audit date
1001	Assignee: Support,Organization	02-02-2015  3:17:42 AM
1001	Assignee: Rohit kumar,status,support	03-02-2015  5:48:42 AM
1001	Assignee:	04-02-2015  6:25:42 AM
1001	Assignee: John kumar	05-02-2015  9:17:42 AM

for example- In this table my output like this

1001

Assignee: Rohit kumar

03-02-2015  5:48:42 AM

Regards

Balram

[#2]

Hi,

Can you attach model data and give more clarity on your requirement.

[tyagishaila]

Hi,

Where do you want to apply wildmatch().?

[#4]

Hi can u pls provide any sample file or any more details

[MayilVahanan]

Hi

Do you have the "name" details separately?

how you know, Assignee fields contains the name or not? Need more information.

[qlikviewwizard]

Hi balrammahato204

Your requirement is not clear. Can you attach the file with the sample data?