Transposing a data table with multiple columns for same label

timjnixon

Hello!

I have a data table with multiple wafers, the tools they pass at a certain step.  Sometimes a wafer may hit multiple tools at the same step.  I am losing toolsets using:

TrSWC = SWC << Transpose(
	columns( :Column ), 
	Transpose selected rows only( 1 ),
	By( :Wafer ),
	Label( :Label ),
	Output Table( "Transpose_Table" )
);	

where SWC=

Wafer	Label	Column
1	X	A
1	X	B
1	Z	C

TrSWC =

Wafer	Label	X	Z
1	Column	B	C

I lose the 'A' tool that wafer 1 hit at label 'X'

Thanks for any help!

 

-Tim

gzmorgan0

@timjnixon ,

 

This can be done with a Table Split, once an additional column that acounts for the number of tools used for that step is created.

The table is attached.  The formula and Split script are embedded in the table and cane be found below

 

 

Split script embedded in the table. Of coursethis can be done with the UI Table>Split

Current Data Table()  << Split(
	Split By( :Step ),
	Split( :Tool ),
	Group( :Wafer, :step count ),
	Remaining Columns( Drop All ),
	Sort by Column Property
)

 The resulting table will look like this

 

If this is not what you want you can also split by step and count

Data Table( "WaferStepSplit" ) << Split(
	Split By( :Step, :step count ),
	Split( :Tool ),
	Group( :Wafer ),
	Sort by Column Property
)

And this creates a table like the one  below

 

WaferStepSplit.jmp