topic create Time from field called WMSTransactionTime in QlikView

create Time from field called WMSTransactionTime

Mon, 04 Oct 2010 20:56:53 GMT

trying to make fields HH MM SS from the word WMSTransactionTime - but having a little bit of an issue. Can someone please tell me if I am on the right track?

maketime(left(SH_Time,2), mid(SH_Time,3,2), right(SH_Time,2)) as [WMSTransactionTime],

Load

WMS_TransactionTime as WMS_TransactionTime,

Hour(WMS_TransactionTime) as WMS_TransactionTime_Hour,

Minute(WMS_TransactionTime) as WMS_TransactionTime_Minute,

Second(WMS_TransactionTime) as WMS_TransactionTime_Second;

receive the following message during debug

Table not found
Store WMS_TransactionTime into ..\..\QVD\WMS_TransactionTime_Transform.qvd (qvd)

is the message because the fields are blank?

create Time from field called WMSTransactionTime

pover — Mon, 04 Oct 2010 21:33:10 GMT

Looks good so far. The only thing I can see that might cause you problems is left(SH_Time,2) being considered text and maketime not accepting the string, but QlikView is usually intelligent enough to figure this out. You'll only know by trying with some real data.

Regards.

create Time from field called WMSTransactionTime

Mon, 04 Oct 2010 21:36:19 GMT

but why would I get the following error during debug?

Table not found
Store WMS_TransactionTime into ..\..\QVD\WMS_TransactionTime_Transform.qvd (qvd)

create Time from field called WMSTransactionTime

Mon, 04 Oct 2010 21:36:54 GMT

the following field SH_Time is a numeric field.

create Time from field called WMSTransactionTime

johnw — Mon, 04 Oct 2010 21:39:47 GMT


smw1013X1 wrote:
but why would I get the following error during debug?
Table not found
Store WMS_TransactionTime into ..\..\QVD\WMS_TransactionTime_Transform.qvd (qvd)<div></div>

Because WMS_TransactionTime is a FIELD. You can only store TABLES into QVDs.

create Time from field called WMSTransactionTime

pover — Mon, 04 Oct 2010 21:41:44 GMT

You have to have a table with the name [WMS_TransactionTime]. To give the table an alias do something like the following:

WMS_TransactionTime: //Table alias followed by a colon just before the load.
Load WMS_TransactionTime,
...

Regards.

create Time from field called WMSTransactionTime

pover — Mon, 04 Oct 2010 21:45:00 GMT

Lol...alright, now you beat me.

create Time from field called WMSTransactionTime

Mon, 04 Oct 2010 21:56:40 GMT

//Time Format is stored as 12:55:01 hours minutes seconds

WMSTransaction_TimeTable:

//maketime(left(SH_TIME,2), mid(SH_TIME,3,2), right(SH_TIME,2)) as [WMS_TransactionTime],

Load

WMS_TransactionTime

Hour

Minute

Second

Load

AutoGenerate

Store

(qvd);

Drop

Table WMSTransaction_TimeTable;

Drop

Created a new name for the table so its left confussion -

Table WMSPickHistory; WMS_TransactionTimeTable into $(Folder_Path)WMS_TransactionTimeTable_Transform.qvd(1) While not IsNull(FieldValue('WMS_TransactionTime',IterNo()));FieldValue('WMS_TransactionTime',IterNo()) as WMS_TransactionTime(WMS_TransactionTime) as WMS_TransactionTime_Second;(WMS_TransactionTime) as WMS_TransactionTime_Minute,(WMS_TransactionTime) as WMS_TransactionTime_Hour, as WMS_TransactionTime,

// see file vwmscnh - field name is SH_TIME