Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
tmumaw
Specialist II
Specialist II

Adding a date for everyday

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

Labels (1)
1 Solution

Accepted Solutions
marcus_sommer

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

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

- Marcus

View solution in original post

3 Replies
Taoufiq_Zarra

for each Equipment ?until ?

can you share a sample data ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
marcus_sommer

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

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

- Marcus

tmumaw
Specialist II
Specialist II
Author

Thanks.  It worked perfectly.