Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Lol...alright, now you beat me.
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.
but why would I get the following error during debug?
Table not found
Store WMS_TransactionTime into ..\..\QVD\WMS_TransactionTime_Transform.qvd (qvd)
the following field SH_Time is a numeric field.
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.
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.
Lol...alright, now you beat me.
//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 -
// see file vwmscnh - field name is SH_TIME