joining tables by date

Heorhi11 — Mon, 05 Feb 2024 08:30:16 GMT

Hello,
I have this problem , I can't merge the table by date , I don't understand why it doesn't merge. I have tables generated by SQL SERVER and link from the table calendar by date.

ODBC CONNECT TO [DRIVER=SQL Server;SERVER=***;UID=***;PWD=***;DATABASE=***];

SQL SELECT

dzial,

ID,

imie,

nazwisko,

ref,

data,

//CONVERT(VARCHAR, data, 104) AS FormattedDate,

//CONVERT(VARCHAR, data, 101) AS FormattedDaateTime,

Day(data) AS Day,

Year(data) AS Year,

Month(data) AS Month,

datepart(ww, data) as KW,

REPLACE(SUBSTRING(przejscie, 3, LEN(przejscie)), '.', '') as Przejscie,

CASE

WHEN Month(data) BETWEEN 1 AND 3 THEN 'Q1'

WHEN Month(data) BETWEEN 4 AND 6 THEN 'Q2'

WHEN Month(data) BETWEEN 7 AND 9 THEN 'Q3'

WHEN Month(data) BETWEEN 10 AND 12 THEN 'Q4'

ELSE NULL

END AS Quarter

FROM "*****";

STORE [Exp_Obec]

INTO [C:\Test\hy\Exp_Obec.qvd] (qvd);

DISCONNECT;

//*************Exp_Obec**********\\

if(len(TableNumber('Exp_Obec')) > 0)

DROP table Exp_Obec;

end if

Exp_Obec:

LOAD

//date(FormattedDate, 'DD.MM.YYYY') as %%Key_V_BelegPos_Datum,

Date(num(data), 'DD.MM.YYYY') as %%Key_V_BelegPos_Datum,

FROM [C:\Test\hy\Exp_Obec.qvd] (qvd);

//************************Kalender_BelegPos*******************************\\

Kalender_BelegPos:

LOAD

//date(Datum, 'MM/DD/YYYY h:mm:ss AM/PM') As %%Key_V_BelegPos_Datum,

date(Datum, 'DD.MM/YYYY') As %%Key_V_BelegPos_Datum,

From [$(ImportPfadExport)global\Zukunftskalender.qvd] (qvd) Where Jahr>2023 and Typ='N';

when I check through by list box(Datum)) as if I don't find and not one record in Exp_Obec. The question is why?
please help!!!

Re: joining tables by date

marcus_sommer — Mon, 05 Feb 2024 08:44:17 GMT

Make sure that the date is really a date and not a timestamp which is only possible with a conversion and not a formatting, for example with:

Date(floor(data), 'DD.MM.YYYY') as %%Key_V_BelegPos_Datum

Re: joining tables by date

Heorhi11 — Mon, 05 Feb 2024 09:40:51 GMT

Thank you very much!!!!!!!!!

topic Re: joining tables by date in Qlik Automate

joining tables by date

Re: joining tables by date

Re: joining tables by date