Script loading

[vikasmahajan]

Dear all

I have following script with stockinoutindicator field while loading data from qvd  now I want to give  following

Condition

============================

(Today()-max([Posting Date])) as [Exp Days Items]

where StockInOutIndicator = '1'  

============================

in same qvd file how to achive this can any one help in this matter.

Script 

=============================

ValueEntry_IAL:

LOAD

if([Valued Quantity] >= 0

   AND

     ((Entry_Type = 0 AND Doc_Type = 5)

   OR (Entry_Type = 1 AND Doc_Type = 3)

   OR (Entry_Type = 2)

   OR (Entry_Type = 4 AND Doc_Type = 10)

   OR (Entry_Type = 4 AND Doc_Type = 0)

   OR (Entry_Type = 6)),1,0) AS StockInOutIndicator  

FROM

   [Source QVDs NAV\Value_Entry.qvd]

   (qvd);

[vikasmahajan]

cAN WE SHOW ALL 4 RECORDS AT A TIME ?

[jagannalla]

Then we need to remove the where conditon...

[vikasmahajan]

Jagan 41193 days appering insted of 73 ? what could be a reson

[jagannalla]

How are you saying that you need 73 ?

It all depends on what we need. Can you attach sample file according to your data what you have now and tell us wt is the output you need according to that data.

Cheers!!

Jagan