Forum Discussion

united2win's avatar
united2win
Icon for Helper III rankHelper III
7 years ago
Solved

How to link two tables together?

Hi,    Any help will be greatly appreciated. I have the following table:   Client Service Required Country Status Company A VAT Registration DE Closed  Company A VAT Registration ...
Need Help
Show and Tell
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    In the second table it seems like you need to split your second column on the dash. Then you are going to need to do something to get the resulting second column from that split into rows, something like an unpivot or pivot. ImkeF should be able to help.

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi united2win ,

If it is convenient, could you share your desired output so that we could understand your logic better?

Best Regards,

Cherry

  • united2win's avatar
    united2win
    Icon for Helper III rankHelper III
    7 years ago

    Hi all,

     

    I'm using the unpivot function as per Greg's suggestion and it's working well. Now, I have encountered another issue where I have three coloumns and I need to combine the data into one coloumn for only countries. Any suggestions? I've attached a screenshot below.