fill up content

[FrankGrimm]

Hello together,

after a load statement, i got the following structure.

I want to fill up the red signed parts with the value wich exist before the empty parts.

But, this value can change, like you see in the first example column.

Thank for your help.

Frank

[Steven35]

Hello Frank,

For example I have the following script:

Data:
LOAD * Inline [
zeile
1
2
3
4
5
];

Left Join(Data)
LOAD * Inline [
zeile, Hauptordner_name
1, Name1
3, Name2
];

Then You can use the "peek" function like this:

NoConcatenate
Data_Final:
LOAD
	zeile,
     If(Len(Hauptordner_name)>0, Hauptordner_name,Peek('Hauptordner_name')) as Hauptordner_name
Resident Data;

Drop Table Data;

Best regards,

Steven

[ogster1974]

[Sheet1]:
LOAD
[zeile],
If(Isnull([Schablone nr]),peek([Schablone nr]),[Schablone nr]) as [Schablone nr],
If(Isnull([Schablone name]),peek([Schablone name]),[Schablone name]) as [Schablone name],
If(Isnull([Hauptordner name]),peek([Hauptordner name]),[Hauptordner name]) as [Hauptordner name],
If(Isnull([Ordner name]),peek([Ordner name]),[Ordner name]) as [Ordner name],
[Recht name],
[Recht wert]
FROM [lib://Community:DataFiles/Fill up data.xlsx]
(ooxml, embedded labels, table is Sheet1);

[FrankGrimm · Accepted solution]

Thanks a lot!! I´ll try it as soon as possible.