Adding a date for everyday

[tmumaw]

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]

for each Equipment ?until ?

can you share a sample data ?

[marcus_sommer · Accepted solution]

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

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

- Marcus

[tmumaw]

Thanks.  It worked perfectly.