Attributes and measures are sent as different data feeds. Join these feeds together, using the Primary Keys, to derive a flattened view of the data.
To get a flattened view at an item or store grain-level, the following join condition is suggested:
- Join Digital Transactability to Item Attributes on wm_item_nbr and op_cmpny_cd
- Join Digital Transactability to Store Dimensions on op_cmpny_cd and store_nbr
- Join Digital Transactability to Product Dimensions on op_cmpny_cd and catlg_item_id
As shown:
Digital Transactability Flattened View
©️Walmart | All Rights Reserved | Confidential
