Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to join tables which does not have unique value columns or have nulls in it

i have a table with raw data and i need to  calculate some aggregations by grouping some columns and i need to join this aggregated table bak to source table to get some details. but the common colum...
Need Help
  • BobBI's avatar
    BobBI
    7 years ago

    Hi Reddy ,

     

    You can combine 2 or more coulmns to create Composite Key .

     

    OR 

    you can copy the source table , strip out all columns except the one or tow  you think can be use as primary key ,

    U se remove duplicate  ( in query editor) and  remove duplicate from the column , Now you will have only unique value in thsi New table then use this new table  in the middle and join source table and aggregated table to this this new table

     

    source table   << New Table>>>aggregated table.

     

    If it doesn't help , share  some data to simulate the solution.

     

    thanks,

    SS