topic Re: Problem in wildmatch and find data in QlikView

Problem in wildmatch and find data

balrammahato204 — Fri, 20 Nov 2020 18:02:30 GMT

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

Re: Problem in wildmatch and find data

Thu, 09 Jul 2015 06:03:36 GMT

Hi,

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

Re: Problem in wildmatch and find data

tyagishaila — Thu, 09 Jul 2015 06:03:40 GMT

Hi,

Where do you want to apply wildmatch().?

Re: Problem in wildmatch and find data

Thu, 09 Jul 2015 06:07:06 GMT

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

Re: Problem in wildmatch and find data

MayilVahanan — Thu, 09 Jul 2015 06:52:44 GMT

Do you have the "name" details separately?

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

Re: Problem in wildmatch and find data

qlikviewwizard — Thu, 09 Jul 2015 07:09:40 GMT

Hi balrammahato204

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