Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
See attachment
Please post an excerpt of your code to clarify your issue.
Hi Andrew,
I haven't used any code. Just created a pivottable, in which the material desc is missing for the unmatched values (values with a -)
Kirsten
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 (-).
Materials
LOAD MaterialID, ProductID
FROM...
LEFT JOIN(Materials)
ProductGroups:
LOAD ProductID
FROM ...
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
See attachment