Merging two fields in a new table without Key (Assignment 1:n)

[Anonymous]

Hi together,

does anyone have any idea how I can solve my problem:

I need per date (1 row) all employees (n rows).

For a join i have no key and concatenate does not help too.

Now:

Date                   EmployeeID

12.05.2018	-
13.05.2018	-
14.05.2018	-
15.05.2018	-
16.05.2018	-
-	7
-	9
-	11
-	12

Goal:

15.05.2018          7

15.05.2018          9

15.05.2018          11

15.05.2018          12

16.05.2018          7

16.05.2018          9

16.05.2018          11

16.05.2018          12

....

Greetings,

Lisa

[big_dreams · Accepted solution]

just do cross join..

Load Date from table1;

join

Load EmployeeId from Table2;

Regards,

[arvind_patil]

Hi  Elisabeth,

What will be your desired output.

Thanks,

Arvind Patil

[keerthika]

Hi,

     Instead of concatenate use outer join...

[Anonymous]

Thank You

[Anonymous]

Hi Arvind,

the example under Goal :-): for each date I need all employees.

Max answer with the join helps.

Somehow, I thought that it would not work without a key.