Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
try below
applymap('test',Rseviarity,null()) as new
Try this
applymap('Testfor_D',RSeviarity,null()) as Sev
Rseviartiy is not a field in the database, where the APPLYMAP-command stands
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
Expression should return. Can you create inline atleast 5 records and check
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 ?
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...
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
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