topic Re: Logic test and rename a mapped field in QlikView

Logic test and rename a mapped field

QVnewbie — Sat, 16 Nov 2024 20:55:55 GMT

Hi everyone,

First post here, this place has helped me a lot by searching and reading only in the past few weeks.

I think I got a question here that is hard to search for.

Question: Can I run a logic test on a mapped field name within the same script.

/*Example section in a standard Load & From script:

Load

...

applyMap(LookUpName, Customer_ID, ' ') as [New Name]

If([New Name] = ' ', 'Exclude', 'Include') as [Name Filter]

...

From...

In my results, [New Name] worked well as it returned the proper mapped name.

But, [Name Filter] just returned blank for all results even [New Name] rows that are not blank.

Can I call a mapped field name this way within the same script?

Appreciate this big time, been scratching my head for two hours on this...

Re: Logic test and rename a mapped field

tresB — Mon, 06 May 2019 07:56:52 GMT

You can't refer a field in the load statement which is created/named in the same load statement. You can rather try like:

applyMap(LookUpName, Customer_ID, ' ') as [New Name]

If(applyMap(LookUpName, Customer_ID, ' ') = ' ', 'Exclude', 'Include') as [Name Filter]

Re: Logic test and rename a mapped field

Vegar — Mon, 06 May 2019 07:57:14 GMT

No you cant, no renames inside a LOAD are available inside for other calculations inside the load. You can however do a preceding load like this.

Table: LOAD *, If([New Name] = ' ', 'Exclude', 'Include') as [Name Filter] ; Load ... applyMap(LookUpName, Customer_ID, ' ') as [New Name] ... From...

Re: Logic test and rename a mapped field

QVnewbie — Mon, 06 May 2019 08:13:02 GMT

That sounds like a reasonable approach, how come I didn’t think of that,
will try it out tonight and advise.

Thanks for that!

Re: Logic test and rename a mapped field

QVnewbie — Mon, 06 May 2019 10:33:45 GMT

Just tried out in QKV, worked really well, learnt something new today.

Thank you champs.

Gavin.