Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
I need to report final data that contains multiple rows and columns of information for the same user. Each column contains different values, but some columns, such as name, phone, and email, may have duplicate values across Multiple rows.
Example: This is my final outcome from the workflow.
| _id | countryCode | dialCode | fullPhone | name | phone | Total Lead Generated for User | Itinerary | Last Lead Date | |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | Mumbai (MH) only | 24-07-2024 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | Delhi (DL) only | 24-07-2024 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | Lucknow (UP) → Ayodhya (UP) | 07-06-2024 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | Ayodhya (UP) only | 24-07-2024 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | Bangalore (KA) only | 24-07-2024 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | Goa (GA) only | 24-07-2024 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | Delhi (DL) → Mathura (UP) → Agra (UP) → Jaipur (RJ) | 18-05-2024 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | Delhi (DL) → Agra (UP) → Mathura (UP) → Delhi (DL) | 24-07-2024 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | Madurai (TN) only | 02-07-2024 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | Delhi (DL) → Rishikesh (UT) | 27-03-2024 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | Delhi (DL) → Agra (UP) → Jaipur (RJ) → Delhi (DL) → Haridwar (UT) → Rishikesh (UT) → Delhi (DL) | 04-04-2023 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | Colombo → Nuwara Eliya → Kandy → Colombo | 24-07-2024 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | Madurai (TN) → Meenakshi Sundareswarar Temple (TN) → Alagar Kovil Temple (TN) → Madurai (TN) → Rameshwaram (TN) → Madurai (TN) | 24-07-2024 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | Hyderabad (TG) only | 02-07-2024 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | Pune (MH) → Bhimashankar (MH) → Pune (MH) | 08-06-2024 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | Jaipur (RJ) → Agra (UP) → Mathura (UP) → Delhi (DL) | 29-05-2024 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | Colombo → Nuwara Eliya → Ashoka Gardens → Ravana Waterfall → Nuwara Eliya | 27-05-2024 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | Amritsar (PB) → Wagah-Attari (PB) → Amritsar (PB) | 18-05-2024 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | Udaipur (RJ) only | 18-05-2024 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | Delhi (DL) → Haridwar (UT) → Rishikesh (UT) → Dehradun (UT) | 18-05-2024 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | Madurai (TN) → Rameswaram (TN) → Periyar National Park (KL) → Kochi (KL) | 18-05-2024 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | Delhi (DL) → Mathura (UP) → Agra (UP) → Udaipur (RJ) | 17-05-2024 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | Madurai (TN) → Rameshwaram (TN) → Madurai (TN) → Kochi (KL) | 17-05-2024 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | Colombo only | 07-05-2024 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | Delhi (DL) → Madhubani (BR) → Mathura (UP) → Agra (UP) → Jaipur (RJ) | 29-03-2024 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | New Delhi (DL) → Mathura (UP) → Agra (UP) → Jaipur (RJ) | 27-03-2024 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | Delhi (DL) → Mathura (UP) → Jaipur (RJ) | 22-03-2024 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | Delhi (DL) → Haridwar (UT) | 22-03-2024 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | Delhi (DL) → Haridwar (UT) → Mathura (UP) → Delhi (DL) | 01-03-2024 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | Lucknow (UP) → Ayodhya (UP) → Lucknow (UP) | 15-01-2024 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | Kolkata (WB) → Mayapur (WB) | 13-04-2023 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | Calcutta (WB) → Mayapur (WB) | 10-04-2023 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | New Delhi (DL) only | 07-04-2023 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | Delhi (DL) → Agra (UP) → Jaipur (RJ) → Haridwar (UT) → Delhi (DL) | 22-03-2023 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | Delhi (DL) → Agra (UP) → Jaipur (RJ) → Delhi (DL) → Rishikesh (UT) | 22-03-2023 00:00 |
| 5e152b79499ea50 | us | 1 | gg@kol.com | 14563775610 | Geet Pers | 4563775610 | 70 | Bombay (MH) only | 17-03-2023 00:00 |
| 5c4684ee249eb5 | in | 91 | prty@gmail.com | 917465575610 | P gi | 7465575610 | 20 | Delhi (DL) → Agra (UP) | 18-10-2023 00:00 |
| 5c4684ee249eb5 | in | 91 | prty@gmail.com | 917465575610 | P gi | 7465575610 | 20 | Delhi (DL) only | 05-04-2023 00:00 |
| 5c4684ee249eb5 | in | 91 | prty@gmail.com | 917465575610 | P gi | 7465575610 | 20 | Mumbai (MH) → Pune (MH) | 20-10-2021 00:00 |
| 5c4684ee249eb5 | in | 91 | prty@gmail.com | 917465575610 | P gi | 7465575610 | 20 | Delhi (DL) → Agra (UP) → Jaipur (RJ) | 28-09-2023 00:00 |
| 5c4684ee249eb5 | in | 91 | prty@gmail.com | 917465575610 | P gi | 7465575610 | 20 | Delhi (DL) → Mathura (UP) | 05-06-2024 00:00 |
| 5c4684ee249eb5 | in | 91 | prty@gmail.com | 917465575610 | P gi | 7465575610 | 20 | Delhi (DL) → Bagdogra (WB) | 05-06-2024 00:00 |
| 5c4684ee249eb5 | in | 91 | prty@gmail.com | 917465575610 | P gi | 7465575610 | 20 | Bangalore (KA) → Chennai (TN) | 08-12-2023 00:00 |
| 5c4684ee249eb5 | in | 91 | prty@gmail.com | 917465575610 | P gi | 7465575610 | 20 | Delhi (DL) → Chandigarh (CH) | 19-04-2023 00:00 |
| 5c4684ee249eb5 | in | 91 | prty@gmail.com | 917465575610 | P gi | 7465575610 | 20 | Chandigarh (CH) → Amritsar (PB) | 04-04-2023 00:00 |
| 5c4684ee249eb5 | in | 91 | prty@gmail.com | 917465575610 | P gi | 7465575610 | 20 | Mumbai (MH) only | 22-01-2019 00:00 |
| 63b98d4c7cb092 | in | 91 | aditya@gmail.com | 8423678383 | A R | 8423678383 | 4 | Udaipur (RJ) only | 29-06-2024 00:00 |
| 63b98d4c7cb092 | in | 91 | aditya@gmail.com | 8423678383 | A R | 8423678383 | 4 | Kolkata (WB) only | 29-06-2024 00:00 |
| 62fd0ca7f290ff0 | in | 91 | shiv@gmail.com | 919066459953 | anand Raaj | 9066459953 | 4 | Dehradun (UT) → Rishikesh (UT) → Haridwar (UT) → Devprayag (UT) → Rishikesh (UT) → Bhim Tal (UT) | 16-06-2024 00:00 |
| 62fd0ca7f290ff0 | in | 91 | shiv@gmail.com | 919066459953 | anand Raaj | 9066459953 | 4 | Dehradun (UT) → Rishikesh (UT) → Bhim Tal (UT) → Bareilly (UP) | 15-06-2024 00:00 |
| 62fd0ca7f290ff0 | in | 91 | shiv@gmail.com | 919066459953 | anand Raaj | 9066459953 | 4 | Tirupati (AP) only | 15-06-2024 00:00 |
| 62fd0ca7f290ff0 | in | 91 | shiv@gmail.com | 919066459953 | anand Raaj | 9066459953 | 4 | Dehradun (UT) → Rishikesh (UT) → Haridwar (UT) → Devprayag (UT) → Rishikesh (UT) → Bhim Tal (UT) → Bareilly (UP) | 17-08-2022 00:00 |
How I want it in my result---------------------------------(checkout atached excel file)
This is my snippet workflow:
