Hi Expects
Seeking your help to merge the outputs. Trying to use transpose + crosstap, seems not went well
Unique Identified: UID
Rule: if UID the same between/among outputs, amend extra field.
Thank you very much
Sample:
1.
UID | CID | Client | Enabled Date | Activity Date | Sales |
123456 | 111 | ABC Inc | 10/3/2022 | 1/3/2023 | Amy |
233333 | 213 | 233 Ltd | 11/2/2023 | 2/6/2023 | Bob |
2.
UID | CID | Client | City | Region |
123456 | 111 | ABC Inc | NYK | America |
123457 | 111 | ABC Inc | LDN | Europe |
222222 | 222 | Super ltd | LDN | Europe |
233333 | 213 | 233 Ltd | SHH | ASIA |
3.
UID | CID | Client | Status | Channel | Requested Date |
123456 | 111 | ABC Inc | Enabled | 9/30/2022 | |
333333 | 333 | TTT Ltd | Pending | Main | 5/1/2023 |
sample output (no matter about order)
UID | CID | Client | Enabled Date | Activity Date | Sales | City | Region | Status | Channel | Requested Date |
123456 | 111 | ABC Inc | 10/3/2022 | 1/3/2023 | Amy | NYK | America | Enabled | 9/30/2022 | |
123457 | 111 | ABC Inc | LDN | Europe | ||||||
233333 | 213 | 233 Ltd | 11/2/2023 | 2/6/2023 | Bob | SHH | ASIA | |||
222222 | 222 | Super ltd | LDN | Europe | ||||||
333333 | 333 | TTT Ltd | Pending | Main | 5/1/2023 |
Solved! Go to Solution.
I'm a bit confused - did you mean amend or append?
The main issue from what I can see is in your data - different tables have different combinations of UIDs. Eg. Table 2 has 222222 which doesn't exist in Table 1.
Can you provide us with the expected output?