Forum Discussion
Add a new column
Hello I have a dataset and want to dontscreens show. I want to add a new colum based on the combination of two that already exist.
Hi Tomasavlis ,
Based on the information you provided, do you want something like this? Extract the values of column 1 and column 2 that are not blank, and if the values of column 1 and column 2 are both not blank, then extract the value of column 1. If I understand correctly, then you can refer to Ashish_Mathur very good method. But here is a question, why is the result of the first row User instead of User1? Or is it just a spelling error that can be ignored?
Best regards,
Mengmeng Li