My source module has no dimensions so How do I use lookup to transfer my data to result module.
My Source file
My Result module
Data should onlu inserted in ABS not other two.
Hi @Nachiketa!
You can use a direct LI link to LI. If you have other LI and dimensions in the module, you can read about Line Items Subset.
Direct LI ??
I'm sorry, I didn't understand your question right away. Am I right to understand that there is a separate module ABS and need to pull data from it into a separate module, where ABS - the value of the directory?
And how should the data be formed on the other elements of the directory?
Yes there is a module where we have only abs values and one where abs is part of dimension so I want to insert values only in abs section.
@Nachiketa
You can write IF else statement on your ABS list.
IF ITem(List) = List.ABS then Source module. line item else 0
Best Practice suggests you to create SYS module dimensioned by ABS list and create one boolean formatted line item. Re write the above formula as
IF SYS ABS module. Boolean line item then Source module.line item else 0
Hope that helps
Misbah
Miz Logix
This is a working approach, but if you have a lot of elements and different sources in the directory - the formula will be too long and opaque.
Yes you are right it won't be a good option if list is long is there no other way like vlookup in excel
If you have many sources, I suggest using LIS mappings:
1. Create an LIS from source modules2. Create an LIS from the target module.3. Create a mapping where you associate the source LIS with the directory items and the target LIS.4. Create a technical module with COLLECT on the source LIS.5. In the target module, make a link to the module with COLLECT and two SUM on the mapping.
The screenshot is a quick example.
Create a line item subset from the line items of the source module.
Add a new line item to the source module making sure it is not automatically added to the line item subset.
Add the line item subset to this new line item via the Applies To column in the blue print.
Use the following formula; COLLECT()
Create a second line item subset of the target module.
Create a mapping table using the line item subset of the target and any other relevant dimensions. Add a line item formatted as the line item subset of the source.
Populate the line item in the mapping to pull allocate the relevant source line item to the combinations of line items and dimensions in the target.
Use LOOKUP to retrieve data from the correct line item in the source as per the mapping. Use the COLLECT() line item in the source as your data source in the LOOKUP.
Hey can you please explain how to map line item subset?
You can choose your LIS as LI Format. From there, it works like a normal list.
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
