No,,this will not help......
My scenario is different from your suggestion.
As per my scenario i want the combinations like:
Booking ID ---> Person ID
EMail---> Person ID
Email---> Booking ID
For example one person having 2 email address for same personID.
one person having multiple booking from same email and personID
Pivot is fine ....but i have to use Nprinting extract nd want to share the file as CSV..........
Instead of Pivot i want table like:
On behalf of Booking ID
On Behalf of Person ID
On Behalf of Email...............
May be Flag or any other mechanism we can use to separate the data............
One more thing is there any way , we can define the occurrence of the field Like.
Booking ID Email occurrance
1 ABC.mail.com 1
2 ABC.mail.com 2
3 xyz.mail.com 1
4 firstname.lastname@example.org 1
but occurrence should be in qlikview script.
See if this kind of script you can use -
Load * inline [
Booking ID, PersonID , Email,
B01, P01 , ABC@mail.com
B02, P02 , XYZ@mail.com
B03 , P01 , ABC@MAIL.COM
B04 , P01 , ABC@mail.com
B05 , P02 , XYZ@mail.com ];
Count([Booking ID]) as BookingCount,
Concat(Email,',') as Email
Group By PersonID;
Drop Table Data;