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
is it an excel file or is it a database table?
Probably peek() or previous(). I always get confused on which is which:
if(len(trim("Model")),"Model",previous("Model")) as "Model"
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.
The fill capability in the script worked like a charm
Retrieving data ...