Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Edit values in query editor

Hi All,   I have 3 columns Check1,Check2 and Date. I would like to add Check3 column in query editor and would like to enter its manually as 2 and 3 for 1st and second row respectively.Is it possib...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

Anonymous is there logic to give value for check3 column, there is many way to achieve this, like add index column or custom column and put the logic there.

 

for changing value, you can replace value function to update the values but you cannot directly edit the values.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi parry2k ,

     

    Thanks for your reply.

     

    There is no logic for adding values in those columns. I would like to manually add those values without any logic.

     

    For Changing values, How to use replace value function?

     

    Thanks

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      6 years ago

      Anonymous in query editor under transform menu

       

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi parry2k ,

         

        Thanks for the reply. But if i have 2 rows and both the rows having value as 4,4 and i would like to change it to 5,6 then with the helpl of replace value function it looks like we ould not able to achieve that.

         

        Thanks