how to repeat the value in loading script

[anya]

hello expert, i have a file like this table

Object	attribute	value
Ball	color	red
	diameter	10 cm
	height	100 cm
Box	color	black
	length	20 cm
	height	16 cm

table that i want 

Object	attribute	value
Ball	color	red
Ball	diameter	10 cm
Ball	height	100 cm
Box	color	black
Box	length	20 cm
Box	height	16 cm

 How am i supposed to do that?

Please Suggest.

thanks

[santhiqlik]

Hi,
Try this in your load script..
If(IsNull(Object), Previous (Object),Object) as Object

[avinashelite]

Try like this 

if(len(trim(Object))=0,Previous(Object),Object) as Object

[Frank_Hartmann]

or maybe this to also cover emptystrings:

if(len(trim(Object))=0, peek('Object', - 1),Object) as Object

[OmarBenSalem]

Please, do as follow:

Table:
load if(len(trim(Object))>0,RowNo(), peek('Flag')) as Flag , Object,attribute, value Inline [
Object, attribute, value
Ball, color, red
,diameter, 10 cm
,height, 100 cm
Box ,color, black
,length, 20 cm
,height ,16 cm
];

Mapping:
Mapping load Flag,Object Resident Table;

Final:

load ApplyMap('Mapping',Flag) as Object,
attribute,
value
Resident Table;
drop Field Flag;
drop Table Table;

Result: