Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
We have availalbe data like this :
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
Now as per scenerio , i dont to miss any data ....
like if i want unique email than my daa should like
ABC@mail.com
XYZ@mail.com
But i want all the Booking ids....not like max of email and limited ids...
same for person id ......if i can say i want unique person than in straight table i want all booking ids and email.......kindly suggest
=distinct(Email)
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
PersonID--> Email
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
.....Please suggest....
Not entirely sure I understand your question. Do you mind re-explaining your question again please?
I think , if you use Pivot table instead of Straight table , then you may get your result ,
I haven't tried , but may be possible .
distinct (email)
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:
3 scenario:
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............
Do you want like this - used =Concat([Booking ID],',') kinda expression
yes you are correct.....but one more addition is required like ...............
i want to do this from flag or button like.................
distinct email and booking ids
distinct booking ids and email
distinct person id and email
distinct email and person ids........
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 aaa@mil.com 1
but occurrence should be in qlikview script.
