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

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

Anonymous — Wed, 16 May 2018 10:27:21 GMT

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

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 — Wed, 16 May 2018 10:29:27 GMT

just do cross join..

Load Date from table1;

join

Load EmployeeId from Table2;

Regards,

arvind_patil — Wed, 16 May 2018 10:34:39 GMT

Hi Elisabeth,

What will be your desired output.

Thanks,

Arvind Patil

keerthika — Wed, 16 May 2018 10:36:07 GMT

Hi,

Instead of concatenate use outer join...

Anonymous — Wed, 16 May 2018 11:45:15 GMT

Thank You

Anonymous — Wed, 16 May 2018 11:50:34 GMT

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.