topic Composite Key with date in QlikView

Composite Key with date

madhuqliklondon — Sat, 16 Nov 2024 18:21:43 GMT

Hi all,

I am creating a composite key to join two tables to get matching values.

I am using below composition but it is returning only up to number, please correct me.

ID &'|'& Number &'|'& Date(Date#( DateTime, 'DD/MM/YYYY HH:MM:SS'),'DD-MM-YYYY') As _Key

Data:

[ ID, Number, DateTime

22,564746474647, 15/07/2020 20:04:45

]

current output: 22|564746474647|

Expected output: 22|564746474647|15-07-2020

Thanks in advance

Kushal_Chawda — Wed, 15 Jul 2020 22:40:23 GMT

try below

ID &'|'& Number &'|'& Date(floor(timestamp#( DateTime, 'DD/MM/YYYY HH:MM:SS')),'DD-MM-YYYY') As _Key

madhuqliklondon — Thu, 16 Jul 2020 11:47:30 GMT

This worked for me

ID &'|'& Number &'|'& Date(Floor( Date(DateTime)),'DD/MM/YYYY') AS _Key

Thank you Kush for your support and time.