Flag

[#1]

Can I get help that how to create morning and evening flag with two sets of qvd's. In single app when i click on morning it should filter morning daa else evening.

Both set of qvd's should be loaded by evening and should be able to analyse. How to create such flag any idea I can get?.

[thomas_skariah]

Hi Suneel,

You can filter the time variation for morning and store it into qvd as morining.

Similar filteration can do for evening also

Regards,

Tom

[#3]

K i have currently same set of qvd's. I want to create with same qvd's morning and evening flag also. So how to create flag after creating two sets of qvd. I want

that flag scripting.

[sivarajs]

You may try with this,

Tab1:

LOAD *,'Morning' as Flag;

LOAD * Inline [

Var,Val2

A,5

B,10

];

Tab2:

LOAD *,'Evening' as Flag;

LOAD * Inline [

Var,Val2

C,15

D,20

];

[thomas_skariah]

Hi,

Not sure whether you are looking for this

sample one

Morning:

load *,

'Morning' as flag

from test.xls

where datetime> '------' and daterime< '----' ;

store Morning into 'your path'.qvd

Evening:

load *,

'Evening' as flag

from test.xls

where datetime> '------' and daterime< '----' ;

store Eveninginto 'your path'.qvd

Regards,

Tom

[#6]

Thanks for your help.

I have nearly 8 qvd's in two sets of qvd's. So if i add flag in morning and evening sets of qvd's and later i will do concatenation. After this I will be having flag filed

in all 8 qvd's. It will create circular reference or synthetic as alreally i have built data model. For this I have a thought but I am not sure whether that works.

My thought is like,  I will comment out flag field in 7 Qvd's except 8 th.Then it filters for all data. I dont this it would filter ....For this i need QV expert's suggestion.

[#7]

We use concatenation always for fact or transactional table right? If so den issue resolved. Please do let me know.