Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Hi Jonathan,
is it an excel file or is it a database table?
Rainer
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