static
1 Topic
Create static table from existing table
Hi all, I cant figure out a possible solutions... hope someone here can help me into the right direction 🙂 Basically I have the following table: Article Competitor Week Value 1 Red 1 100 1 Red 2 300 1 Red 3 500 1 Red 4 700 2 Green 4 200 2 Blue 2 400 2 Blue 3 100 2 Blue 4 500 I want to create a new table where I only retrieve 1 row per article + competitor for the latest (max) week. So it would look like this: Article Competitor Week Value 1 Red 4 700 2 Green 4 200 2 Blue 4 500 I tried selectedcolumns, but then I would get an error saying: "A table of multiple values was supplied where a single value was expected" Im now kinda stuck. Does anyone have an idea? Thanks in advance! 🙂Solved785Views0likes3Comments