topic How to combine two columns info and remove redundant info? in Discussions

How to combine two columns info and remove redundant info?

Fruit325 — Wed, 25 Sep 2024 13:01:27 GMT

Hi I want to get some advice of combining columns.

Here I have column 1 and 2 and these two columns are actually containing the same info of interest. I want to combine them together and remove repeat info.

Original table:

Column1 Column2

1 1

3 3

Final table:

Column

Thank you!

Re: How to combine two columns info and remove redundant info?

jthi — Wed, 25 Sep 2024 13:14:15 GMT

If they are always same, you can create new column which is some summary statistic of those columns (min, max, mean, median,...)

Then delete the formula from new column and rename it

And then remove old columns if you want to

Re: How to combine two columns info and remove redundant info?

Fruit325 — Sun, 29 Sep 2024 11:59:07 GMT

Oh that's a good idea and I have not thought abou it...

So.. what if the values are categorical...?

Re: How to combine two columns info and remove redundant info?

jthi — Sun, 29 Sep 2024 14:54:09 GMT

If they are numerical categorical you can still use that kind of approach. If they are characters, there are still many different options and which to use can depend a little bit on your data, below is one simple example

If(
	Is Missing(:Column 1), :Column 2,
	Is Missing(:Column 2), :Column 1,
	:Column 1
)