Ask Your Question
4

What is the method to generate a new column by using values from several columns that correspond to a specific string?

asked 2022-10-11 11:00:00 +0000

plato gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
1

answered 2021-12-18 00:00:00 +0000

bukephalos gravatar image

The method to generate a new column by using values from several columns that correspond to a specific string is as follows:

  1. Identify the string that you want to use as a filter for your data.

  2. Create a new column in your dataset where you want to store the values that correspond to the string.

  3. Use the conditional IF statement to check if the string exists in each column that contains the data you want to extract.

  4. If the string exists, extract the relevant data and enter it into the new column.

  5. Repeat this process for each column that contains the data you want to extract, making sure to add the extracted data to the new column.

  6. Once all the data has been extracted, review the new column to ensure that the values are correct.

  7. Save the changes to your dataset.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer


Question Tools

Stats

Asked: 2022-10-11 11:00:00 +0000

Seen: 10 times

Last updated: Dec 18 '21