7 Replies Latest reply: Nov 3, 2015 2:01 AM by Markus Haindl RSS

    Merging multiple fields into one

    Markus Haindl

      Hello,

       

      I have a table in which there is the same information in two different representations. The two fields can be ether both filled, or one of the fields is filled. I'd like to make one extra field, where the information is gathered.

       

      One example:

      brandmodelHPkW
      FordMustang304224
      FordMustang GT350392
      BMWM3 GTS444
      BMWM5560412

       

      Now I need a new field "Power". That field contains ether the kW value, the cenvrted HP value (HP/1,36) or both. The result would be:

      brandmodelPower
      FordMustang224
      FordMustang223.529
      FordMustang GT350392
      BMWM3 GTS326.470
      BMWM5412
      BMWM5411.764

       

      Thank you for your help, I'm a little bit lost here.

       

      Thank you

       

      Markus

       

      Edit: I've changed the decimal seperator from , to . for clarification.