Fill column with above data

[Anonymous]

Hi,

I have a raw data like this:

Regional	Area
A	AA
	AB
	AC
B	BA
	BB

I want to fill blank regional column with the value above.

So the record will be like this:

Regional	Area
A	AA
A	AB
A	AC
B	BA
B	BB

Is it possible to make it ?

Thanks in advance.

[sumit_ranjan_pa]

Hi Chou,

This is possible but solutions might depend on the data.

Can you please provide more details or your load query and sample data for this?

Is there any condition you have which is making the load on the first column possible or you want it to be random filled?

Thanks and regards,

Sumit

[stonecold111]

if(regional=null(), above(regional))

use this in script

[avinashelite · Accepted solution]

Try like this

IF (len(trim(Regional)) = 0, peek('Regional'), Regional) AS Regional,

[Anonymous]

Hi Avinash,

Thank you very much, it solved my problem perfectly.

[avinashelite]

Glad to help you