Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a field in my load script called 'STATUS'. Via applymap I translate this value into an Expression.
Now I want to create in the script a variable, that gives me the translated Expression back.
Currently I have in my script:
LOAD
...
STATUS as asset_statuscode,
ApplyMap('map_coda_number_codes',STATUS) as asset_status,
...
FROM
$(DirDataQVD)efa_asset.qvd
(qvd);
I tried this, but it is not working:
LET varCons = ApplyMap('map_coda_number_codes',STATUS) where STATUS ='1490'
Does someone of you have an idea?
Chris
or you can simply filter the Value in Mapping load itself
Hi chanty,
thank you it works. But one last question.
I created this variable in a script-qvw (structure file).
My working qvw (it is a layout file) is filled binary with the data from script file.
In this layout file the variable is not there. I think it has something to do with the calcualtion.
Do you know what happens?
Chris
if u do binary load the sheet objects and variables will not come to ur Qvw. only data model will appears.
u can copy objects if u hve same field names in current qvw.
thank you very much to all of you.
It works now.
I guess, Suresh was mentioned the semicolon at the end of the statement.
LET varCons = ApplyMap('map_coda_number_codes',1490) ;
)))) facepalm
LET varCons = ApplyMap('map_coda_number_codes',1490) ;