Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a question.
I have a table "Employes" and a table "Datas".
Like this :
Employes :
| KeyUser | Name | ||
|---|---|---|---|
| 080503 | Community Qlik ! | ||
| 080504 | Smiley cool | ||
| 080505 | No records |
Datas :
| Date | KeyUserCreate | KeyUserModify |
|---|---|---|
| 13/04/2015 | 080503 | 080504 |
| 14/04/2015 | 080503 | 080503 |
| 14/04/2015 | 080504 | 080503 |
I would like this result
| Date | KeyUserCreate | NameCreate | KeyUserModify | NameModify |
|---|---|---|---|---|
| 13/04/2015 | 080503 | Community Qlik ! | 080504 | Smiley cool |
| 14/04/2015 | 080503 | Community Qlik ! | 080503 | Community Qlik ! |
| 14/04/2015 | 080504 | Smiley cool | 080503 | Community Qlik ! |
I've tried to create two tables Employes but it doesn't works.
Could you help me?
Thanx
The file attached with the same script.