creation of qvd

[sat_tok52]

Hi Gurus,

I have to store my qvd today data and yesterday data for comparison ,how to create that.Any help

Thanks,

Sateesh

[trdandamudi]

If you have your data in one table then follow below example to store it into a QVD file:

Final_Data:

LOAD * INLINE [

    Year, Order,Amount,Flag

    2009, 2345,,1

    2010, 4565,,0

];

Store Final_Data into C:\Temp\Sample.qvd (QVD);

[HirisH_V7]

Hi sateesh,

You want to create qvd means, you can look into trdandamudi‌ post.

Else ,what type of comparison,

-Day to day means you can do it in front end using various charts

Can you elaborate more about your data and requirement.

-Hirish

[raju_insights]

Hi Sateesh,

Sample Script:

Data:

LOAD * INLINE [

    Date, Dimension, Measure

    9/4/2016, A, 1

    9/5/2016, B, 2

    9/6/2016, C, 3

    9/7/2016, D, 4

];

NoConcatenate

Comparision:

Load * Resident Data

Where Date(Date)>=Date(Today()-1); //Apply condition to filter today and yesterday data

Drop Table Data;

Store * from Comparision into Comparision.qvd; //To store the table as qvd

Drop Table Comparision;

Exit Script;