Autofill blank (grouped) Excel values from previous row on load in Sense

[qluser01]

Hi!

I need to load an Excel file into SENSE

Table has grouped rows (see example)

In QlikView I can use Fill Cells option.

How to do it in Sense????

See attached XSLX file for example, try to load it...

[qluser01 · Accepted solution]

I did it using Previous() command like:

load

if ( len(col1)<=0, Previous(col1), col1) as col1

...