topic Re: Error in QlikView

Error

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

HI ALl,

I have writtena Apply Map in the script .

and after reloading it gives me the error .

please find the screenshot of the error and the script

Tahnks in Advance

Re: Error

Chanty4u — Tue, 19 Sep 2017 07:41:19 GMT

try below

applymap('test',Rseviarity,null()) as new

Re: Error

prma7799 — Tue, 19 Sep 2017 07:46:46 GMT

Try this

applymap('Testfor_D',RSeviarity,null()) as Sev

ApplyMap ‒ QlikView

https://community.qlik.com/thread/98764

Re: Error

prieper — Tue, 19 Sep 2017 07:54:05 GMT

Rseviartiy is not a field in the database, where the APPLYMAP-command stands

Re: Error

dinuwanbr — Tue, 19 Sep 2017 08:06:33 GMT

Hi Roy,

What is the error you are getting?

Here I hope that error is nothing but there may be no records to be mapped or there may be more than one value to be mapped (hence showing the very first value)

Before you do apply map please check whether

there are one [Ready for Release] for each RSeverity in Test_for_D.

It has to be a one value only. If not you can't do an apply map.

Rgds,

Tharindu

Re: Error

Anil_Babu_Samineni — Tue, 19 Sep 2017 08:11:05 GMT

Expression should return. Can you create inline atleast 5 records and check

Re: Error

smilingjohn — Tue, 19 Sep 2017 08:24:03 GMT

Hi Anil ,

There too much of data no need to create records using inline table .

But still this is giving the same error.

I changed the fields and added ApplyMap

but still dosnot work ...

It gives the same error , like field not found

I am doing anything wrong ?

Re: Error

jonathandienst — Tue, 19 Sep 2017 08:24:32 GMT

Please stop trying to fix the ApplyMap statement - there is nothing wrong there.

As Peter R has already said, the field RSeviarity is not a field in the table where you are using the ApplyMap...

Re: Error

effinty2112 — Tue, 19 Sep 2017 08:29:37 GMT

Hi John,

You've commented out the RSeverity field that your ApplyMap statement is looking for. QV is giving you a good clue -

Field not found - <RSeverity>

cheers

Andrew

Re: Error

Anil_Babu_Samineni — Tue, 19 Sep 2017 08:34:24 GMT

May be field consider in mapping table as space after word. Try to use the simple ApplyMap or with out that load only first QVD

Re: Error

Colin-Albert — Tue, 19 Sep 2017 08:41:58 GMT

Where are you loading the data from for the test2 load?

Your screen shot is missing the details of the from line.

Does the field RSeverity exist in the table you are loading test2 from?

Re: Error

smilingjohn — Tue, 19 Sep 2017 08:50:22 GMT

Hi Collin,

No the Test2 Table doesnt have RSeverity field ...

Iam trying to bring it by using the apply map function

Re: Error

dinuwanbr — Tue, 19 Sep 2017 09:04:23 GMT

Hi Roy,

If RSeverity field is not available in the second table, then apply map won't work.

This general syntax will help you to understand.

Map_Table_Name:

Mapping

Load

Mapping_key,

Field_to_be_Mapped

From....

Second_table:

load

Applymap('Map_Table_Name',Map_Field_From_Second_Table,'Not Available then') as Fileld,

.....

from

......

Here Map_Field_From_Second_Table is nothing but the Key in the Second_Table which is tallying with Mapping_key in the Map_Table

Rgds,

Tharindu

Re: Error

Colin-Albert — Tue, 19 Sep 2017 09:07:02 GMT

The ApplyMap function is used to translate a field from one value to another. The field you are translating must exist in the data.

The source data for test2 MUST contain RSeverity then applymap function will translate the value and return the second value from the mapping table. If the data does not contain RSeverity, then you get the error you are seeing.

Look at this post to see how Applymap works.

Don't join - use Applymap instead

Re: Error

hari8088 — Tue, 19 Sep 2017 09:32:27 GMT

Hi,

when your writing the applymap syntax in the table you have to give the field name for comparison with in the table.

example:

Map:

Mapping load

id,name

from map.xlsx;

table:

load

ids,

applymap('Map',ids) as name,

sal,

dept

from sales.xlsx;

as you see above example am comparing id and ids and am mapping name.

while writing the field name have to give comparing field name that is available with in the table.