How to do it at UI

[kunkumnaveen]

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

i want to do this at front end (UI)

Thanks in advance.

[sumeet-vaidya]

Hi Naveen,

While loading data from excel, please follow below steps to Fill blank records with previous values.

Enable Transformation Steps -> Fill -> Fill button -> Cell Condition (is empty) -> Next - Finish

Eg:-

LOAD

     Region,

     Area

FROM

test_123.xls

(biff, embedded labels, table is Sheet1$, filters(

Replace(1, top, StrCnd(null))

));

Regards

Sumeet

[kunkumnaveen]

cant write any set analysis? i want to do it at front end

[kunkumnaveen]

By the data source is not Excel

[kunkumnaveen]

Cant we can do it  at front end?

[PrashantSangle · Accepted solution]

Yes we can do it front end as well as in back end

Front End

Dimension: Area

Expression  : If(len(Trim(Regional))=0,Above(Regional1),Regional)                // Give Expression Name as Regional1

Back End

Use peek() try below

if(len(Trim(Regional))=0,Peek(Regional),Regional) as Regional

Then use Use Regional field in front end.

Regards

[sumeet-vaidya]

Hi,

Yes, Use Above function as stated below,

If(Isnull(Region) OR len(Trim(Region))=0, Above(Region_New),Region) ==> Name this expression as Region_New

Regards

Sumeet