Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi @Sugarp , you can fill the empty cells using peek() function
Example :
Aux:
Load * INLINE [
Number, Title, Category
1, Emergency, Group
,, name
,, location
,, nationality
,, local
,, non critical
,, Critical
2, Risk, Group
,, name
,, location
,, nationality
,, local
,, non critical
,, Critical
];
Data:
Load
if(isnull(Number) or Number = '', peek(Number1), Number) as Number1,
if(isnull(Title) or Title = '', peek(Title1), Title) as Title1,
Category
Resident Aux;
drop table Aux;
exit script;
Here is how to make hierarchy:-
Load * INLINE [
Number, Title, Category
1, Emergency, Group
,, name
,, location
,, nationality
,, local
,, non critical
,, Critical
2, Risk, Group
,, name
,, location
,, nationality
,, local
,, non critical
,, Critical
];
Data:
Load
if(isnull(Number) or Number = '', peek(Number1), Number) as Number1,
if(isnull(Title) or Title = '', peek(Title1), Title) as Title1,
Category
Resident Aux;
drop table Aux;
exit script;