topic Adding a date for everyday in QlikView

Adding a date for everyday

tmumaw — Sat, 16 Nov 2024 18:53:10 GMT

Hi all,

I have a table with has an equipment number on it for example:

Equipment

123456

I need to create a another column on the table for a date, so the table would look like this.

123456 01/01/2020

123456 01/02/2020

123456 01/03/2020

Etc.....

How can I do this?

Thanks

Taoufiq_Zarra — Thu, 26 Mar 2020 09:25:43 GMT

for each Equipment ?until ?

can you share a sample data ?

marcus_sommer — Thu, 26 Mar 2020 10:35:31 GMT

You could use a join to create additionally records, for example:

load distinct Equipment from A;
join
load distinct Date from B;

- Marcus

tmumaw — Thu, 26 Mar 2020 16:56:47 GMT

Thanks. It worked perfectly.