Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

create Time from field called WMSTransactionTime

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?

1 Solution

Accepted Solutions
pover
Luminary Alumni
Luminary Alumni

Lol...alright, now you beat me.

View solution in original post

7 Replies
pover
Luminary Alumni
Luminary Alumni

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.

Not applicable
Author

but why would I get the following error during debug?

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

Not applicable
Author

the following field SH_Time is a numeric field.

johnw
Champion III
Champion III


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.

pover
Luminary Alumni
Luminary Alumni

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.

pover
Luminary Alumni
Luminary Alumni

Lol...alright, now you beat me.

Not applicable
Author

//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