difference of QVD data

[sanjujeeboy]

I have a qvd with current hour data:

 hour    sales

  20         1000

i have another qvd with previous hour data 

Hour   sales 

19        500 

how can i  do difference in qvds in back end to get output as 

Hour  Sales

  1        500

[Chanty4u]

Hi try this

a:
LOAD * , AutoNumber( hour & '|' & sales) AS UID
Inline [
hour , sales

20 , 1000

];
b:

LOAD * , AutoNumber( Hour & '|' & Sales) AS UID inline[
Hour ,Sales

19 , 500
];

EXIT SCRIPT;

[Reyyeess]

Thanks for the update and quick reply. I'll be sure to keep an eye on this thread. Looking for the same issue. Bumped into your thread. Thanks for creating it. Looking forward for solution.