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
small change for abve
LET varCons = ApplyMap('map_coda_number_codes',1490);
chk dis
Hi chanty,
thanks for your help with the link.
I am not very good at this, so I unfortunately dont understand everything.
Would you please translate this for me for my script.
Thanks
Chris
what ur exctly tryng to do?
hi chanty,
the Status 1490 is the code in the Oracle database for under construction.
the applymap is the Translation to get rid of the code and use the Expression.
I want to have a variable with this Expression.
Chris
is this?
LET varCons =' ApplyMap('map_coda_number_codes',STATUS) where STATUS ='1490' ';
hello!
try this
LET varCons = ApplyMap('map_coda_number_codes',1490)
Hi,
Simply try,
LET varCons = ApplyMap('map_coda_number_codes','1490')
small change for abve
LET varCons = ApplyMap('map_coda_number_codes',1490);
hm, what is difference between your post and my post? )))