Pivot table/ Straight table

[#1]

I have a data structure as below:

Datum	Bestuurder ID Source1	Bestuurder ID Source2
21/03/2011	348682014
21/03/2011	348958000
21/03/2011	933481004
21/03/2011		348682014
21/03/2011		348958000
21/03/2011		933481004

But now I want to get a table in qlikview with the following data:

Datum	Bestuurder ID Source1	Bestuurder ID Source2
21/03/2011	348682014	348682014
21/03/2011	348958000	348958000
21/03/2011	933481004	933481004

To see if the bestuurder ID in Source 1 is filled in and bestuurder ID in Source 2 is filled in.

Does anyone have a solution for this issue?

[deepakk]

hi,

Try out the attach application.

[#3]

Thanks. But this is not the solution for me because in the original structure I have also the field Source.

This is the original dataset:

Datum	Bestuurder ID Source1	Bestuurder ID Source2	Source
21/03/2011	348682014		1
21/03/2011	348958000		1
21/03/2011	933481004		1
21/03/2011		348682014	2
21/03/2011		348958000	2
21/03/2011		933481004	2

So in this set it is impossible to make a join in the script. Because I need the field source for another object in my qlikview document.

[deepakk]

hi,

If you have Source field then what will be final output. Because if you add the source to your output the value will be duplicated.

Deepak