Forum Discussion
Unable to filter a stylecode
I have a data model with a Y2_Sales table containing sales data, another Y2_Style table with all item information, and a final Y2_Style_color table containing item information at color level. Tab...
Did you try the suggestion of concatenation of style code and color to create the key?
I don't see how I can do this, as the stylecode in Y2_Style is unique and the data is emptied every night and extracted from another program. Each stylecode has several colors, so I'd have to make 1 line with each color, but the stylecode would no longer be unique...