17 Replies Latest reply: Mar 31, 2016 1:17 PM by pavan nallani RSS

    variable in script

    Christian Wylezol

      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