Hi,
Would like to ask if I can lookup a list item which is classify as a parent list? I tried it but it does not work. I got values using lookup if the list classify as child list.
Thank you.
Darlene
Hi DM,
It appears the DIR COA list is a ragged hierarchical list. In the ragged hierarchy, lookup works at the child level, not at the parent/summaries. As an alternate for Lookup use Select function.
Why do you not want to use Select function, Is it a production list?
~Vignesh M
@DMManalili , Could you share some screenshot of what you are trying with an explanation?
I created a staging module to lookup the value.
first, below is the screenshot of the list.
second is the system module for the mapping
third is the calculation module, I used select function because I cannot get the values if I used lookup, but I want to use lookup instead.
hi VM,
Noted for this. I was just thinking if its better to use lookup rather than select but I will use select instead.
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
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…
