showing fields

[narender123]

Hi All,

I have  a script like:

LOAD IED_ID,

     DOC_VER,

     OP_NAME,

     if(OP_NAME='Store',CLOSED_DATE_TIME) as Stored_Date_Time,

     if(OP_NAME='Agent Release',CLOSED_DATE_TIME) as Agent_Validated_Time,

     if(OP_NAME='Total Discharge',CLOSED_DATE_TIME) as Released_Date_Time,

     NEW_GEN_REG_TIM,

     CLOSED_DATE_TIME,

     OP_DATE_TIME,

     C_BINDER_ID,

from table;

I set a expression in my table

=Interval(Released_Date_Time - NEW_GEN_REG_TIM, 'hh:mm:ss')

and the columns are

Stored_Date_Time    Agent_Validated_Time   Released_Date_Time     NEW_GEN_REG_TIM    

But in result it is showing  data in         Released_Date_Time  and    NEW_GEN_REG_TIM dimention with expression result.

Why the      Stored_Date_Time    and     Agent_Validated_Time showing null value??

[Chanty4u]

did u cross chk with ur original data? is that hvng null values?

[Anonymous]

enhance your table by field CLOSED_DATE_TIME and OP_NAME and verify the Content and your condition in script

only if OP_NAME doesnot have values like 'Store' or 'Agent Release' then null will be calcluted in target field

else problem with lower/upper characters?

[#4]

Hi Narendra,

Could you check the data once whether the

if(OP_NAME='Store',CLOSED_DATE_TIME) as Stored_Date_Time,

     if(OP_NAME='Agent Release',CLOSED_DATE_TIME) as Agent_Validated_Time

is evaluating.

[narender123]

Hi Chanty,

I checked my data all fileds have value.

where Released_Date_Time is present only at that place both Stored_Date_Time and Agent_Validated_Time will be absent.

But in table only Released_Date_Time data is visible .

But when i used other expression rather than subtraction both Stored_Date_Time and Agent_Validated_Time showing value.             

Thanks.

Narender

[narender123]

Thank you for reply.

Please see my reply to Chanty.

Narender

[narender123]

Thank you for reply.

Please see my reply to Chanty.

Narender

[avinashelite]

can please share the sample data and the desire output format so that it will helpful for us to give the solution ..

[jonas_rezende]

Hi, Narender Makhija.

The my suggestion would be word insert of test. After reload, see if appear in ListBox of fields Stored_Date_Time    and    Agent_Validated_Time. Example:

LOAD IED_ID,

     DOC_VER,

     OP_NAME,

     if(OP_NAME='Store',CLOSED_DATE_TIME,'Test Store Date Time') as Stored_Date_Time,

     if(OP_NAME='Agent Release',CLOSED_DATE_TIME,'Test Agent Validated Time') as Agent_Validated_Time,

     NEW_GEN_REG_TIM,

     CLOSED_DATE_TIME,

     OP_DATE_TIME,

     C_BINDER_ID,

from table;

Value appears with the occurrence test?

Hope this helps!