Help needed with nested if and else statement

ENTHU

I'm using if else statement to bucket certain FS*/SS* as CAT1 and CAT2 .All remaining FS*/SS* that do not belong to CAT1/CAT2 need to be classified as CAT3.

Having trouble with writing else part for CAT3.Any help appreciated.

 

cdt = open("temp\data.csv");

cdt=current data table();
sum_lst2 = {};
sum_lst3 = {};
sum_lst4 = {};
col_lst2 = cdt << get column names( Numeric );
For( i = 1, i <= N Items( col_lst2 ), i++,
	colname = Column( col_lst2[i] ) << get name;
	If( Contains( {"SS008","SS009","SS010","SS015","SS053","FS9429","FS9792","FS9906","FS9908", "FS1302","FS1305","FS1308","FS1360","FS1373","FS2744","FS4621","FS4625","FS4630","FS4640","FS4681","FS4830"}, colname ) | (colname >= "FS2900" & colname <= "FS2950") | (colname >= "FS3400" & colname <= "FS3450"),
		Insert Into( sum_lst2, col_lst2[i] )
	); ///Cat1//	
	
	If( Contains( {"SS098","SS090"}, colname ) | (colname >= "FS9700" & colname <= "FS9791") | (colname >= "FS9793" & colname <= "FS9799"),
		Insert Into( sum_lst4, col_lst2[i] )
	);//Cat2//
	If( Contains( {"SS019","SS027","SS035","FS9901"}, colname ) | (colname >= "FS3451" & colname <= "FS3499"),
		Insert Into( sum_lst3, col_lst2[i] )
	);//Cat3
);

Item	FS0100	FS0847	FS0875	FS0876	FS0877	FS1059	FS1061	FS1090	FS1315	FS1501	FS1503	FS1505	FS1537	FS1539	FS1541	FS1543	FS1559	FS1590	FS1930	FS1933	FS2706	FS2740	FS2742	FS2745	FS3416	FS3417	FS3418	FS3422	FS3423	FS3455	FS3469	FS3471	FS3492	FS3493	FS5391	FS9429	FS9792	FS9901	FS9906	SS001	SS008	SS010	SS013	SS015	SS019	SS027	SS034	SS053	SS094	SS097	SS099
1	132	1																	3																				1	132	1				3						1
2	600	2																	7	2		1	4				5			1	4					1	1	1	2	600	2		0		9	5	10		1	1	3
3	562					1													9			1	1			1	1	1	2	1	1	1	1	2				2	1	562		1			9	2	11				3
4	527	2		2	1		2	1		7		2	4	3	3	2		24	18	2	3			1	2		1		1		4		1	1	1	3			2	527	5	3		45	20	4	10	1	3		2
5	322		1						1		2						1		7				3											2					3	322	1		1	3	7	3	2			0	3

 

Joseph_Reese

How about something like the below? I didn't actually see any "else" statements in your script since you used the glue operator between If() statements. See below where I have nested all your If() statements and then had the final else as the Insert Into the sum_lst4 list (assuming that was where you wanted the Cat4 column names.

 

cdt = Current Data Table();
sum_lst2 = {};
sum_lst3 = {};
sum_lst4 = {};
col_lst2 = cdt << get column names( Numeric );
For( i = 1, i <= N Items( col_lst2 ), i++,
	colname = Column( col_lst2[i] ) << get name;
	If(
		Contains(
			{"SS008", "SS009", "SS010", "SS015", "SS053", "FS9429", "FS9792", "FS9906", "FS9908", "FS1302", "FS1305", "FS1308", "FS1360", "FS1373",
			"FS2744", "FS4621", "FS4625", "FS4630", "FS4640", "FS4681", "FS4830"},
			colname
		) | (colname >= "FS2900" & colname <= "FS2950") | (colname >= "FS3400" & colname <= "FS3450"),
		Insert Into( sum_lst2, col_lst2[i] ), ///Cat1//	
	
		If( Contains( {"SS098", "SS090"}, colname ) | (colname >= "FS9700" & colname <= "FS9791") | (colname >= "FS9793" & colname <= "FS9799"),
			Insert Into( sum_lst4, col_lst2[i] ), //Cat2//
			
			If( Contains( {"SS019", "SS027", "SS035", "FS9901"}, colname ) | (colname >= "FS3451" & colname <= "FS3499"),
				Insert Into( sum_lst3, col_lst2[i] ),
				Insert Into( sum_lst4, col_lst2[i] )///final nested else statement for Cat4
			);//Cat3
		)
	);
);