Forum Discussion

clankenau's avatar
clankenau
Frequent Visitor
8 years ago
Solved

Creating relationships between two text files

I'm unable to create a relationship between two text files in Power BI.  The first text file (Shipping Cost) contains two columns (Pick Ticket & Shipping Cost) while the second text file (Shipping) c...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi clankenau,

     

    As msornakumar suggested, to ensure the uniqueness of Pick Tickets , you can count the records for each Pick Ticket.

     

    Besides, please remove duplicates (in query editor, right click the Pick Tickets field in first file) and create relationship again.

     

    Best regards,

    Yuliana Gu

msornakumar's avatar
msornakumar
Advocate III
8 years ago

Hi ,

 

Per your statment , below you are trying to relate shipping cost to pick tickets. Is that a typo ? Are you trying to relate Pick tickets to Pick Tickets. ?

 

Ultimately, I'm trying to link the shipping cost in the first text file (Shipping Cost) to the Pick tickets in the second text file (Shipping). 

 

To ensure the uniqueness of Pick Tickets , you can try building a quick visualization similar to below and filter on Count > 1

 

 

 

 

Thanks

 

Sorna

clankenau's avatar
clankenau
Frequent Visitor
8 years ago

That was a typo.  I'm trying to link the pick ticket in each file.

 

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi clankenau,

     

    As msornakumar suggested, to ensure the uniqueness of Pick Tickets , you can count the records for each Pick Ticket.

     

    Besides, please remove duplicates (in query editor, right click the Pick Tickets field in first file) and create relationship again.

     

    Best regards,

    Yuliana Gu