Forum Discussion
exporting underlying data to excel resulted multiple lines
Hi,
I have a table report which is built from 2 tables. These 2 tables have a one-to-many relationship.
When I exported the underlying data from this table to excel, it resulted multiple lines for 1 row. While the visual table shows the correct information from the combined tables.
What I have:
Table #1
| Item No | Location |
| 1 | Location A |
| 2 | Location B |
| 3 | Location A |
| 4 | Location C |
| 5 | Location C |
| 6 | Location A |
| 7 | Location D |
Table #2
| Location | Status |
| Location A | Open |
| Location B | Expired |
| Location C | Expired in 2018 |
| Location D | Open |
Table 1 & Table 2 relationship is set by the Location.
The underlying data exported is a follow
| Item No | Location | Status |
| 1 | Location A | Open |
| 1 | Location A | Expired |
| 1 | Location A | Expired in 2018 |
| 2 | Location B | Open |
| 2 | Location B | Expired |
| 2 | Location B | Expired in 2018 |
| 3 | Location A | Open |
| 3 | Location A | Expired |
| 3 | Location A | Expired in 2018 |
| 4 | Location C | Open |
| 4 | Location C | Expired |
| 4 | Location C | Expired in 2018 |
| 5 | Location C | Open |
| 5 | Location C | Expired |
| 5 | Location C | Expired in 2018 |
| 6 | Location A | Open |
| 6 | Location A | Expired |
| 6 | Location A | Expired in 2018 |
| 7 | Location D | Open |
| 7 | Location D | Expired |
| 7 | Location D | Expired in 2018 |
Is there any thing I missed out that caused this data multiple exported?
