Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

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

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

1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

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

just do cross join..

Load Date from table1;

join

Load EmployeeId from Table2;

Regards,

View solution in original post

5 Replies
Highlighted
Creator III
Creator III

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

just do cross join..

Load Date from table1;

join

Load EmployeeId from Table2;

Regards,

View solution in original post

Highlighted
Partner
Partner

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

Hi  Elisabeth,


What will be your desired output.


Thanks,

Arvind Patil

Highlighted
Creator II
Creator II

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

Hi,

     Instead of concatenate use outer join...

Highlighted
Contributor III
Contributor III

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

Thank You

Highlighted
Contributor III
Contributor III

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

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.