topic Re: Determine FileName Prefix in QlikView

Determine FileName Prefix

Fri, 19 Oct 2012 14:07:34 GMT

Hi Guys,

I try to determine the prefix set on the file name.

On the first hand, i have a list of prefix available and already loaded (table FilesPrefixs)

On the other hand, i have a folder containing a list of files as Input.

The goal is to determine what is the correct prefix to execute the correct SUB.

What i have done at this time :

DeterminePrefixTemp:

LOAD FileNamePrefix

RESIDENT FilesPrefixs

WHERE SubStringCount(SubField($(vFileName),'-',1), FileNamePrefix) > 0;

For example :

> vFileName contain ABCD1243-20120101-195312

> FileNamePrefix is supposed to contain : ABCD

The result is an error : Unknown Field : ABCD

I don't understand where is my problem.

Do you have an idea on what i'm doing wrong.

Thanks a lot for your help.

Gysbert_Wassenaar — Fri, 19 Oct 2012 14:27:26 GMT

Your table FilesPrefixs does not have a field named ABCD. So LOAD ABCD ....etc fails.

MayilVahanan — Fri, 19 Oct 2012 14:35:41 GMT

SubStringCount(SubField('$(vFileName)','-',1), FileNamePrefix)

I think error you occur, field not found <ABCD>..

if not, please check the data in fieldnameprefix

That helps

Fri, 19 Oct 2012 14:35:53 GMT

The field i'm loading from FilesPrefixs is : FileNamePrefix not ABCD

and i want to identify the row preseting the value ABCD.

Fri, 19 Oct 2012 14:58:19 GMT

Hi Mayil,

you're right, this was the problem.

Thanks a lot.