topic Crete new column from existing column in App Development

Crete new column from existing column

Sra1bandi — Thu, 15 Jun 2023 11:10:31 GMT

Hi Team,

i have column

0-100

100-200

200-300

300-400

400-500

500-600

600-700

700-800

800-900

900-1000

i need to create new column based on above is

0-200

200-400

400-600

600-800

800-1000

Regards,

Sravan.

Re: Crete new column from existing column

jonashertz — Thu, 15 Jun 2023 15:39:17 GMT

Not sure what your purpose is but it looks like you need to take min max value for every second RecNo (Note difference to RowNo).

I purposely changed the row order and added an OrderBy just to be sure.

Subfield() without third parameter adds one row per subfield in the table.

t1:

Load * Inline [

Values

0-100

100-200

200-300

300-400

400-500

700-800

800-900

900-1000

500-600

600-700

];

t2:

Load

subfield(Values,'-') as Values,

RecNo()-Odd(RecNo()) as DoubleRecNo

Resident t1

Order by Values

;

drop table t1;

t3:

Load

min(Values) & '-' & max(Values) as Values

Resident t2

group by DoubleRecNo;

drop table t2;