nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

qspringleaf

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

Accepted answers

txnelson

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"
);

All comments

txnelson

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"
);

qspringleaf

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.

txnelson

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"
);