Importing into a numbered list and module

Hi Anaplanners,

I have a query, I have a numbered list KKT with display name property and I have made a KKT DET module dimesioned with KKT and has line items code and name. These line items use formula code(item(KKT)) and KKT.display name.

To create actions I used a file to load KKT list and then same file to load KKT DET module. It is loading fine.

Now, I am running the actions from informatica and what I see is the Name is blank in KKT DET module, also KKT list items appear as #24,#25.... (Identifiers).

Please suggest what could be wrong here.

Thanks

Accepted answers

TristanS

That's strange. This should be basic numbered list configuration. Might be missing a step your configuration. I'm assuming you still have the changes I recommended. If you do can you check the following:

1. the name line item in KET DET is populated (screenshot 1). Notice when it's populated the list has a name otherwise it has # numbers.

2. go to "General lists", look for KET and in the column Display Name property it should have display name or the name of the property you created (screenshot 2)

3. go to the "Properties" tab in the KET list and the formula is populated (screenshot 3)

screenshot 1:

screenshot 2:

screenshot 3:

ryan_kohn

It's very likely you are missing a mapping or trying to import the name on top of an existing formula.

You should have two import actions. I believe you're already doing this.

The source file must contain Code and Name. You probably have other columns, but I'll ignore those for this purpose.

Step 1: Import into the KKT list. Map: Code->KKT.Code. The Display Name property should contain a formula, per @TristanS's guidance. You will not be able to map Name here.

Step 2: Import into the KKT module. Match items on Code. Map: Name->Display Name. The Display Name line item should not contain a formula.

Lastly, it's probably also worth checking that you actually have selected your list property as the list's Display Name Propety in General Lists:

You can read more on Anapedia about how to create display names for numbered lists in Anaplan.

All comments

TristanS

@kamil101

There's several ways this can happen

1. Display name property against the list (see yellow highlighted section below) has not been set

2. the display name property in the list is blank as per #2 in screenshot below

Having said that you usually set the display name as a formula, e.g.

name line item in KTT DET usually doesn't have a formula. You load the value in to this line item

and then in your list you have a formula that points to KTT DET module.

kamil101

Hi, thanks trying it but no luck.

I already have display name property, I changed the formula for it as suggested and also loaded name in the module from file.

TristanS

1. the name line item in KET DET is populated (screenshot 1). Notice when it's populated the list has a name otherwise it has # numbers.

2. go to "General lists", look for KET and in the column Display Name property it should have display name or the name of the property you created (screenshot 2)

3. go to the "Properties" tab in the KET list and the formula is populated (screenshot 3)

screenshot 1:

screenshot 2:

screenshot 3:

ryan_kohn

It's very likely you are missing a mapping or trying to import the name on top of an existing formula.

You should have two import actions. I believe you're already doing this.

The source file must contain Code and Name. You probably have other columns, but I'll ignore those for this purpose.

Step 1: Import into the KKT list. Map: Code->KKT.Code. The Display Name property should contain a formula, per @TristanS's guidance. You will not be able to map Name here.

Step 2: Import into the KKT module. Match items on Code. Map: Name->Display Name. The Display Name line item should not contain a formula.

Lastly, it's probably also worth checking that you actually have selected your list property as the list's Display Name Propety in General Lists:

You can read more on Anapedia about how to create display names for numbered lists in Anaplan.

kamil101

@ryan_kohn @TristanS

Thank you so much for help! It worked. 🙂

ryan_kohn

@kamil101 Great news and glad to hear it! When you get a chance, please go ahead and mark one or both of our answers as solutions. Thanks!

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…