Discussion Board for collaboration on QlikView Scripting.
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.
just do cross join..
Load Date from table1;
Load EmployeeId from Table2;
View solution in original post
What will be your desired output.
Instead of concatenate use outer join...
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.