topic Re: Overwrite data in a table in Discussions

Overwrite data in a table

LGaspard — Thu, 08 Jun 2023 16:38:45 GMT

Hi,

I am trying to clean up my data table. I have a table with some value which are "x", "X", "X-Direction", "X-direction", but they are all the same, which is "X".

How can I change the values (in the script) so it overwrite everything with the same format ("X")?

Because then, I want to split my data table and it gives me 4 columns where I should have only 1... Thanks!

Re: Overwrite data in a table

jthi — Fri, 03 Feb 2023 14:50:56 GMT

One option is to use Recode:

Select your values you wish to recode

Press Group

Select how you wish to recode them

And finally press Recode

Changed this:

to this

And if you have JMP16+ you can get the code from action recorder

// Recode column: Column 6
Local({dt},
	dt = Data Table("Big Class");
	dt << Begin Data Update;
	dt << Recode Column(
		dt:Column 6,
		{Map Value(
			_rcOrig,
			{"X-Direction", "X", "X-direction", "X", "x", "X"},
			Unmatched(_rcNow)
		)},
		Update Properties(1),
		Target Column(:Column 6)
	);
	dt << End Data Update;
);

Or from Recode menu before you press Recode

Re: Overwrite data in a table

LGaspard — Fri, 03 Feb 2023 15:01:31 GMT

It works!! Thanks :))