About kevin.cho

Hi @ismaelmaclovio    It's best if you can show your progress, and then I can guide you through the next/correct steps to get the right outcome.    As per my previous post, did you check the "Size" list? What were the entries in this list? Did you complete activity 4.6.9 properly? Please provide a screenshot of your "Size" list (in the Grid View mode) if you are confident that you ahve.    For the series of lists that make up the Product Hierarchy, think carefully about which attributes in each file correspond to the Code, and Parent, for each item.   E.g. in the Product Families.csv file, you have two attributes: 1. Family Code 2. Family Name   From these, you can map the Family Code to the "Code" property of the list, and the Family Name to the "Name" property of the list.    For the Products.csv file (in activity 4.6.7), you have four attributes now: 1. Product Code 2. Product Name 3. Family Code 4. Size   Within the P2 Products list, you would have three attributes that you need to map to: 1. Code --> Product Code seems the most sensible here 2. Name --> Product Name seems the most sensible here 3. Parent --> Given that the P2 Products list rolls up into the P1 Product Family list, and each item in the P1 Product Family list was identified by the "Family Code" attribute, then you can use the "Family Code" attribute to populate the parent.    If you are still having further problems, please send through screenshots of each respective list in Grid View mode - Grid View provides a bit more detail, including the Code, Parent and any other list properties.    ... View more

Oh I see! Okay, so you have been using the non-system Users list, i.e. a "Fake" users list (similar to Fake Time).    The system Users list has this special behaviour that allows the filter to still be applied; your situation is akin to using just a default type of list, which yes does need the dimension being applied.   You can potentially still do this however by creating two line items; one against the Users list formatted with "User List", and then another boolean formatted which you apply as a filter. If there is a mapping between the System "Users" list and your non-System "User List", create a line item that returns the item from the System "Users" list.  E.g.  If Approved By is the name of the line item formatted by "User List", then you can do something like below (assuming names of the items in "User List" are email addresses that correspond to the system User list) Mapped User = FINDITEM(Users, NAME(Approved By)) You can then do everything as previous, but now referencing this "Mapped User" line item.      Is there a reason why you use your own "User List" rather than "Users"?          ... View more

I'm interpreting this as:   "1. We want to delete records which has the same value for the "Code" as the "Employee ID" property in another record 2. We want to then update the codes with the employee ID, such that the two are aligned".   Is this correct?   If so: To solve for 1., create a module with 5 line items, dimensioned against "Employees" (or the appropriately named list).  Line Item Name Formula Format Note Employee ID Employees List.Employee ID Text Assuming the "Employee ID" is stored in a Text field in the list as a property.  Employee ID Item FINDITEM(Employees List, Employee ID) Employees List Converts the Employee ID value into the item we want to retrieve.  Employee List Item ITEM(Employees List) Employees List Returns self Employee item Exists in Other? 'True Flag'[ANY: Employee ID Item] AND Employee ID Item <> Employee List Item Boolean Checks if the Employee ID is already the code of any item, excluding itself True Flag TRUE Boolean Helper line item   You can then create a "Delete from List Using Selection" action using the "Exists in Other?" boolean formatted line item. This will mark any record that has its Code as the same value as "Employee ID" in any other record.    Example - where B is the new record that contains the Employee ID of A.    2. To update the code,  Create two line items:  Code (if not already existing in your system module) = CODE(ITEM(Employees List)) Code mismatch? = Employee ID <> Code   Create a saved view with columns showing "Employee ID", and filter on "Code Mismatch?" = TRUE  Create an import matching on Name, and updating the Code value mapped to "Employee ID".    If you can ensure that this runs in a process so that step 1 (deletion) occurs before step 2, then you can stop here; otherwise, better to include some more checks in Step 2 to ensure you don't try to create records with duplicate codes (as the action will error out and cause a poor user experience).      ... View more

Got it 🙂     Please double check the blueprint carefully! In particular, the field for the "Applies To" for the line item "Safety Stock Flag Count".   You'll see that the value in "Applies To" field is " " (blank). This means that there is no dimensionality (besides Time) applied to this line item.   Please change this to "-" (a hyphen/dash). This will then make the line item the same dimensionality as the module.  ... View more

For combinations of logical AND and logical OR, you should create a new line item that incorporates this logic, and then apply that new line item as a filter.    I.e.   A, B, C are your boolean criteria D and E are your number criteria   Create new line item that has formula: A AND B AND C AND (D OR E) ... View more

I just went back into the lesson content just to double check.   You're importing into a module dimensioned by the list "Location Flat". Each item in this list should correspond to an item in the "Locations.csv" source file in lesson 1.3.3.3, with codes ranging from G001 (New York) to H001 (Head Office).   If this is not correct, you'll need to review that first.    Your Locations.csv import into the SYS07 module should then match 1-1 - it's the exact same data source used to populate the list.      ... View more