topic Aplatir une table in Discussions

Aplatir une table

FlorenceJMP — Thu, 03 Oct 2024 10:35:07 GMT

Bonjour,

Est il possible dans JMP de joindre plusieurs colonnes en 1 seule ligne à partir d'un identifiant, autrement dit: passer du premier tableau au second?

Merci

NOM

Prénom

item 1

item 2

item 3

item 4

frzegfze

fez

224

fez

GRZGR

xcsq

GZE

GFEZ

GZE

GFEZ

GZE

NOM

Prénom

item 1-1

item 2-1

item 3-1

item 4-1

item 1-2

item 2-2

item 3-2

item 4-2

item 1-3

item 2-3

item 3-3

item 4-3

frzegfze

fez

224

fez

GRZGR

xcsq

GZE

GFEZ

GZE

Re: Aplatir une table

hogi — Thu, 03 Oct 2024 11:01:41 GMT

in the second table, "G" shows up twice. with GFEZ and QD?

Re: Aplatir une table

hogi — Thu, 03 Oct 2024 11:11:45 GMT

You could stack and then split the data.
To stack the columns, they have to have the same format. So maybe some additional step are necessary to align the formats and set them back to the original format.

dt = New Table( "demo",
	Add Rows( 7 ),
	Compress File When Saved( 1 ),
	New Column( "NAME",
		Character,
		Set Values( {"frzegfze", "he did", "he did", "GRZGR", "GZE", "GZE", "GZE"} )
	),
	New Column( "First name",
		Character,
		Set Values( {"he did", "he did", "he did", "xcsq", "GFEZ", "GFEZ", "QD"} )
	),
	New Column( "item 1",
		Character,
		Set Values( {"A", "B", "C", "D", "E", "F", "G"} )
	),
	New Column( "item 2",
		Character,
		Set Values( {"12", "3", "4", "5", "2", "7", "8"} )
	),
	New Column( "item 3",
		Character,
		Set Values( {"224", "5", "67", "5", "31", "2", "0"} )
	),
	New Column( "item 4",
		Character,
		Set Values( {"a", "b", "c", "d", "e", "f", "g"} )
	)
);

dt << New Column( "entry",
	Formula( Col Rank( Row(), :NAME, :First name ) ),
);

dtstacked = dt << Stack(
	columns( :item 1, :item 2, :item 3, :item 4 )
);


dtsplit = dtstacked <<
Split(
	Split By( :entry, :Label ),
	Split( :Data ),
	Group( :NAME, :First name )
);