Forum Discussion

mokrane_bob's avatar
mokrane_bob
Frequent Visitor
7 years ago
Solved

Get two column with value from another column

Hello,

 

It's simple what i want to do but i can't reach it.

I have this 

Now i want to have two columns which will be filled according to the colomn source.

If the type is Newsletter => this will be filled in the new column for Newsletter.
if the type is Enquête => this will be filled in the new column for Enquête

Thank you

Need Help
  • Arul's avatar
    Arul
    7 years ago

    Hi mokrane_bob ,

    You have to do this applied steps in your edit queries.

     

    Go to edit queries and then,

    1.Duplicate that column

    2.Promote first row as headers

    3.Replace value for column 1

    4.Replace value for column 2

     

    Regards,

    -Arul

1 Reply

  • Arul's avatar
    Arul
    Super User
    7 years ago

    Hi mokrane_bob ,

    You have to do this applied steps in your edit queries.

     

    Go to edit queries and then,

    1.Duplicate that column

    2.Promote first row as headers

    3.Replace value for column 1

    4.Replace value for column 2

     

    Regards,

    -Arul