Forum Discussion

RMV's avatar
RMV
Helper V
9 years ago

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 f...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

RMV,

Could you please post a screenshot about how you create the table report? I am not able to reproduce your issue.


Regards,
Lydia

  • RMV's avatar
    RMV
    Helper V
    9 years ago

    Hi Anonymous,

    Not sure I can attach a picture. Hope this works

     

    table

    • RMV's avatar
      RMV
      Helper V
      9 years ago

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      RMV,

      Please show that how you create visual using the sample data you post, there is an example for your reference.


      Regards,

      Lydia

      • RMV's avatar
        RMV
        Helper V
        9 years ago

        Hi Anonymous,

         

        Here's the screenshot

        1. Table #1: engine status

         

        2. Table #2: contract

         

         

        3. Relationship between engine status & contract (many-to-one)