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...
I did it using Previous() command like:
if ( len(col1)<=0, Previous(col1), col1) as col1
Retrieving data ...