variable in script

[#1]

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

[Chanty4u]

chk dis

Let Statement

[#3]

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

[Chanty4u]

what ur exctly tryng to do?

[#5]

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

[Chanty4u]

is this?

LET varCons =' ApplyMap('map_coda_number_codes',STATUS) where STATUS ='1490' ';

[t_chetirbok]

hello!

try this

LET varCons = ApplyMap('map_coda_number_codes',1490)

[tamilarasu]

Hi,

Simply try,

LET varCons = ApplyMap('map_coda_number_codes','1490')

[Chanty4u · Accepted solution]

small change for abve

LET varCons = ApplyMap('map_coda_number_codes',1490);

[t_chetirbok]

hm, what is difference between your post and my post? )))