Forum Discussion

Jcramb's avatar
Jcramb
Frequent Visitor
7 years ago

Lookupvalue from Grouped Table want to return Aggregate Value

I have a large table of all my schedule updates.  Each monthly schedule update contains the same schedule activity so the table has multiple times rows of the same activity (20 or more as i add updat...
Need Help
Jcramb's avatar
Jcramb
Frequent Visitor
7 years ago

the related function will not let me link to the Summary Table.

Eventhough the summary table has 1 row per Activity ID i think it thinks that there are mulitple Activity ID's.  I cant make a relationship directly between the to tables. I get this error one of the two tables need unique values in the column.

Jcramb's avatar
Jcramb
Frequent Visitor
7 years ago

I tried making a another table with only the Activity ID's from the same data set and used the Remove Duplicates in the query but when i go to make the relationship it still errors with one of the columns has to has unique values.  I dont get it i used remove Duplicates but is still seems to think there is muiliple vaules for the same Activity ID.

  • v-cherch-msft's avatar
    v-cherch-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi Jcramb

     

    It seems you may add a column to check if there are any duplicate rows as below:

     

    Regards,

    Cherie