How to create hierarchy in load editor(inline load) or any other way

[Sugarp]

 

[QFabian]

Hi @Sugarp , you can fill the empty cells using peek() function

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecordFun...

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;

[parkerpalmer]

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;