Some of my material names (material desc) for some materials are not visible in my pivottable, but are available in the datafile. The material names (product) that are not visible in the pivot, are material names that can not be mapped to a productgroup (PPG). Other material names that can be matched with PPG are visible. This mapping is active in my dashboard
Is it possible to make the invisible material names visible?
I believe the two tables you have joined are joined backwards. In other words your code should look like this. Or if using the association engine you should make the product groups is joining on materials and not the other way around. This should show all materials and IF they have a Product group it will show otherwise it will be null (-).
LOAD MaterialID, ProductID
Sorry for the delayed response. I haven't used a code similar to above. The files are uploaded on sharepoint a script is added in data load editor > load data. And then in datamanager: synchronize scripted tables, and under recommended associations > apply all