Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
HamdiGA
Contributor
Contributor

Concatenate dates From different source

Hello,
I am trying to concatenate two tables from the différent source (logFile and database) basing on the date filed.
But the problem is that Qlik displays only the date of the first table and convert to a number the second date filed.

HamdiGA_0-1612871749920.png

 

1 Reply
Almen
Creator
Creator

Have you tried to transform the fields in your script?

 

Like

 

Table1:
LOAD
Date(Table1.Date) as Date,
Time(Table1.Date) as Time,
...
...
From YourSource1;

Table2:
LOAD
Date(Table2.Date) as Date,
Time(Table2.Date) as Time,
...
...
From YourSource2;