Lookup or anyother ways

AnAnnie

Is there any way to lookup or connect the "Distribution Center" from the second table with the first table?

thanks

Accepted answers

All comments

AjayM

Hi @AnAnnie ,

Ideally, you shouldn't be connecting second table with the first using LOOKUP. Second table is dimensioned by SKU and distribution center, while the first table is dimensioned only by SKU (based on the screenshot).

If not in Anaplan learning course context, one SKU can be sold/distributed to multiple distribution centers, which is maintained in second table. Since first table is only by SKU list, you could aggregate the inventory by SKU level using a formula. Or add distribution center dimension to first module and then fetch data using an import action or formula.

Cheers!

Quick Links

Can you help?

Unanswered questions

In the L2 we were discussing about intermediary module to connect the Source and Target
How to connect the growth % which has the Product family as dimension with the P3 SKU using intermediary module..I'm stuck Can someone help?
ADO connection from postgreSQL
Hi everyone, I am trying to create a connection ADO from PostgreSQL, but I consistently receive the following error: Failed to establish a connection The following message was sent from the target system: The SSL certificate is either invalid or not in unencrypted PEM format. Please check your certificate and try again.…
RTO and RPO details required
For auditing purpose I need RTO and RPO details. Could you please share the details and also along with the source URL.