To pull or not to pull?: Loading Distribution List to SYS07 Location Details Module (Lvl 2 220.127.116.11)
This is an exercise to create a data hub and, as a preparation, I have asked to load data in a flat list in a preset structure as per below:
Please note that there is Distribution Center? field to it, which was already set when I uploaded this assigned model. Since it is there, I have uploaded the true/false boolian values from locations.csv file as per attached:
Then this particular task is to load the rest of the information from locations.csv into SYS07Location Details Module, which was pre-set like this:
So, I have uploaded the data as per:
As I was suspecting that the "Distribution Center?" information would be pulled through from the Location Flat list, I did not import this particular field. But there is no lookup formula preset for Distribution Center values in this module.
So, my question is this:
Above made me think whether or not I need to upload this data separately from the Location Flat list. But if so, what is the point of uploading this value in the Location Flat list as we are duplicating the Distribution Center? values in two places defeating the purpose for the single place of truth, which was what User Story by the Model Builder wanted.
OR, do I need to work on the formula on SYS07 so to pull the data from the Location Flat list?
Any pointer to the right direction would be much appreciated!