4 Replies Latest reply: Oct 26, 2011 12:49 PM by Josh Duenyas RSS

    add character to value

      hello community, is there a function to add characters to a value during load ?

       

      F.e. in Excel, there is a function [="1_"&C58] which would add 1_ to the data from C58.

      So "1234" would end up as "1_1234" OR  "cake" would become "1_cake"

       

      the same is possible on other positions of the value

      F.E. ="A_"&C58&"_B" would become "A_1234_B"

       

      Is there something similar in qlikview ?

       

      Thanks

      alex