topic how to fill columns missing content with a required content by JSL in Discussions

how to fill columns missing content with a required content by JSL

qspringleaf — Fri, 09 Jun 2023 18:13:12 GMT

kindly help to suggest how to fill columns missing content with a required content by JSL, from left to right, auto fill in missing content with "Sold", refer to below tables. (actually the table and the columns is not limited, more than the table list). many thanks

Find on JSL but not work, :Name("Sold or not?")[ dt<< get selected rows ] = "Sold";

Column Name	Sold or not?			Column Name	Sold or not?
Apple	Not			Apple	Not
Orange				Orange	Sold
pineapple	Not	--->'	pineapple	Not
blueberry				blueberry	Sold
durain	Not			durain	Not
pear				pear	Sold
banana				banana	Sold

Re: how to fill columns missing content with a required content by JSL

txnelson — Wed, 16 Mar 2022 03:46:18 GMT

Here is one way of handling your issue

Names Default To Here( 1 );
dt = Current Data Table();

colNames = dt << get column names( string, character );

For( i = 1, i <= N Items( colNames ), i++,
	Column( dt, colNames[i] )[dt << get rows where( As Column( dt, colNames[i] ) == "" )] =
	"Sold"
);

Re: how to fill columns missing content with a required content by JSL

qspringleaf — Wed, 16 Mar 2022 04:01:21 GMT

Many thanks for the solution, if the table have more than two columns with content missing, how to fill in content only for specific colomn while not touching other columns?(like this table, only want to fill the column "Sold or not?") can help to suggest and many thanks.

Re: how to fill columns missing content with a required content by JSL

txnelson — Wed, 16 Mar 2022 04:07:54 GMT

Names Default To Here( 1 );
dt = Current Data Table();

colNames = dt << get column names( string, character );

// Just loop across the colNames list and remove the column 
// names that you don't want
For( i = N Items( colNames ), i >= 1, i--,
	If( Contains( colNames[i], "Sold or not?" ) == 0,
		Remove From( colNames, i, 1 )
	)
);

For( i = 1, i <= N Items( colNames ), i++,
	Column( dt, colNames[i] )[dt << get rows where( As Column( dt, colNames[i] ) == "" )] =
	"Sold"
);