Forum Discussion
matdub40
Helper III
Helper IIIUnable 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...
audreygerred
Super User
Super UserDid you try the suggestion of concatenation of style code and color to create the key?
matdub40Helper III
Helper IIII 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...