Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the next Excel tabel and i want to transform it into another format.
Source;
The table in QV should look like this.
Can anyone help me out here, I 've tried (see the attached QV file) but I didn't get to the right result.
Thnx in advance!!
add this code to the load script:
finalTable2:
load
'new' as dummy,
fProduct,
fDate,
sum(FactA) as FactA,
sum(FactB) as FactB,
sum(FactC) as FactC
resident finalTable
group by fProduct,
fDate;
drop table finalTable;
drop field dummy;
hi,
not sure if you just wantthe result in a chart or if you are looking for an actaul table with three Facts A, B and C.
The attached qvw shows how to achieve both.
the chart solution can be built straight out of what you already have.
The table solution requires some more code in the script.
I'm looking for a actual table with the three facts, the example you sent me is almost the solution;
But I want the facts on one row so I can perform calculations on row level and not only on aggregated level.
add this code to the load script:
finalTable2:
load
'new' as dummy,
fProduct,
fDate,
sum(FactA) as FactA,
sum(FactB) as FactB,
sum(FactC) as FactC
resident finalTable
group by fProduct,
fDate;
drop table finalTable;
drop field dummy;
That's it!! Thnx!!