Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
DipeshVadgama
Partner - Creator II
Partner - Creator II

Seperate Date,Time & Country

Hi,

How to Separate date, Time & Country in load

My Data contains like below

13/Apr/2017 19:32 Europe/London

01/Jul/2017 Asia/Calcutta

1 Solution

Accepted Solutions
sunny_talwar

May be like this

Date#(SubField(FieldName, ' ', 1), 'DD/MMM/YYYY') as Date,

Time#(SubField(FieldName, ' ', 2), 'hh:mm') as Time,

SubField(FieldName, ' ', 3) as Country

View solution in original post

3 Replies
sunny_talwar

May be like this

Date#(SubField(FieldName, ' ', 1), 'DD/MMM/YYYY') as Date,

Time#(SubField(FieldName, ' ', 2), 'hh:mm') as Time,

SubField(FieldName, ' ', 3) as Country

Clever_Anjos
Employee
Employee

Sufield(yourfield,' ',1) as Date,

Sufield(yourfield,' ',-1) as Country,

If( Sufield(yourfield,' ',-1)  <> Sufield(yourfield,' ',2),Sufield(yourfield,' ',2)) as Time

DipeshVadgama
Partner - Creator II
Partner - Creator II
Author

Thanks Your both function works