An interesting load question

[#1]

I'm trying to load a file where the metrics are grouped by the first column, grouped as showen below

So for example, I sold Fords on 10/1-10/5. How can my QV Load regonized 10/2/-10/5 as belonging to Ford?

My result should look like the following

[#2]

Hi Jonathan,

is it an excel file or is it a database table?

Rainer

[johnw]

Probably peek() or previous(). I always get confused on which is which:

if(len(trim("Model")),"Model",previous("Model")) as "Model"

[Anonymous · Accepted solution]

I answered a similar questiong here in the past - search for "fill with previous". I think it was peek() function. And load should be sorted correctly.

[#5]

The fill capability in the script worked like a charm