missing data in dim table

[jbirco]

i import data from a transactional system there is a salesdetail table containing a column with a numerical identifier for the items and a description column that names the product, the numerical identifier is related to a dim table that contains further detail about the product i.e. the brand , supcat and category. the problem is that the items table is missing the items that are no longer sold. so i need to add those missing info based on the description from the salesdetail table and add the subcat and category based on similarly named products in the items table

[jbirco]

sorry the previous link was not good, i hope this one works sample salesdetail.xlsx

[edhans]

I don't understand your data @jbirco - Am I supposed to match the UPC code? you have UPC codes like "199" - I've never seen UPC codes like that. They are always 12chars or more in most scenarios.

And none of the 16 records in your sales table exist in the items table.

[jbirco]

thanks for your insight i am including a sample data for your reference  https://izzytoday-my.sharepoint.com/:x:/g/personal/jb_izzy_today/EcEumOtShtRPoNDdPMpjoMoBrmYM1JuqsJj...

[edhans]

You effectively need to do this:

1. Find all items in your sales FACT table not in your item DIM table. a not List.Contains()  would work, as would other scenarios.
2. Convert that list to a table.
3. use the decription to do a fuzzy merge (probably) to get the info from the item table.
4. Append that table to your item table.

This is very difficult to help with without any data, so please provide source data and expected results per the instructions below. In otherwords, this is a process to assist with, not terribly complex code. But sample data always! 😁

How to get good help fast. Help us help you.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.