Matching values and coding them

Apurva14

So I have many same values(eg;-12345) in multiple columns by months I wanted to keep the values in the first column as numbers and code the rest if present or absent as 0 and 1. 

 

One more thing about the data I have is that some values are unique but they are not in the first column how can stack them above one another and still code them by month. 

 

 

this what my data looks like 

Jan	Feb	March	April	May	June	July	August
11111	22222	11111	11111	11111	22222	11111	22222
33333	33333	44444	55555	11111	33333	22222	1111
and so on

 

say for example 

111111

0

1

1

0

1

0

I want it to look like these !! 

any help is appreciated @staff

ron_horne

welcome @Apurva14 

have a look at this solution.

please let us know if it is in the right direction

 

New Table( "Untitled",
	Add Rows( 4 ),
	New Column( "Jan", 
		
		Set Values( [11111, 33333, 44444, 55555] )
	),
	New Column( "Feb ", 
		
		Set Values( [22222, 33333, 11111, 55555] )
	),
	New Column( "March", 
		
		Set Values( [11111, 44444, 22222, 11111] )
	),
	New Column( "April ", 
		
		Set Values( [11111, 55555, 33333, 33333] )
	),
	New Column( "May ", 
		
		Set Values( [11111, 11111, 44444, 55555] )
	),
	New Column( "June", 
		
		Set Values( [22222, 33333, 44444, 55555] )
	),
	New Column( "July ", 
		
		Set Values( [11111, 22222, 22211, 55555] )
	),
	New Column( "August", 
		
		Set Values( [22222, 1111, 44444, 22222] )
	)
);
	

// here is where the work starts 
dt = Current Data Table();

cols = dt << get column names( string );
ncols = N Items( cols );
For( i = 1, i <= ncols, i++,
	Eval( Parse( "dt << new column (cols[i+1], Formula(" || Char( cols[1] ) || " ==" || Char( cols[i + 1] ) ) )
);
	

best,

Ron