Question Re: how to create duplicate node at target in Technology Q&A

how to create duplicate node at target

Former Member — Wed, 06 Jan 2016 06:52:36 GMT

Hi,

I am facing some issue in PI mapping where I want to generate the nodes twice at target structure based on condition.

At source, API_RESPONSE can come once or multiple times. If ratetype is Daily then one EXCHANGE_LIST will be generated. If ratetype is monthly, we need both EXCHANGE_LISTs.

In mapping, I created duplicate sub tree and did mapping giving condition but while testing, I am not getting two EXCHANGE_LIST.

We need both Daily and Monthly data differently in both structures. Please help.

Thanks,

Swapnashree

Re: how to create duplicate node at target

engswee — Wed, 06 Jan 2016 06:59:33 GMT

Hi Swapnashree

It should be due to incorrect context. Change context of "@rate_type" to one level higher.

Rgds

Eng Swee

Re: how to create duplicate node at target

justin_santhanam — Wed, 06 Jan 2016 07:08:24 GMT

Hi Swapna,

So I assume you don't have any problem in generating the Daily type ExchangeList node. The problem is with Monthly - ExchangeList node correct?

In the Mapping on

"then" - remove the API_RESPONSE - Map With Default.

"then" - Just put a empty Constant there.

After that Please right click on If then step and Choose Display queue and give us the screenshot. It will help us to see where is the issue.

Thanks!

Re: how to create duplicate node at target

Former Member — Wed, 06 Jan 2016 07:20:51 GMT

Yes, issue is with Montlhy.

Are you talking about this:

Not working

Re: how to create duplicate node at target

Former Member — Wed, 06 Jan 2016 07:21:29 GMT

I changed it to API_RESPONSES but no result.

Re: how to create duplicate node at target

justin_santhanam — Wed, 06 Jan 2016 07:31:16 GMT

Hi Swapna,

Try this.

Change the Context of @rate_type to API_RESPONSES and follow the below one:

@rate_type - UDF - EXCHRATE_LIST.

UDF:

Create UDF with type of Queue and import 1 parameter (name - input type- string)

for (int i =0; i< input.length;i++)

{

if(input[i].equals("Monthly"))

{

result.addValue("");

}

This will work.

Question for you - Based on the queue I can see there are 3 API_RESPONSE , there will only 1 Monthly and 2 Daily? But still you are creating only one EXCHRATE_LIST for daily?

Thanks!

Re: how to create duplicate node at target

manoj_khavatkopp — Wed, 06 Jan 2016 07:33:01 GMT

Hi ,

The occurrence of EXCHRATE_LIST is 1..1 , you need to change this.

Br,

Manoj

Re: how to create duplicate node at target

yeeloon-khoo — Wed, 06 Jan 2016 07:34:29 GMT

Hi Swapna,

you have to change change context for @rate_type as mentioned by Eng. Use node function createIf for better readability.

Try below:

(right-click, change @rate_type context to one level higher API_RESPONSE)

@rate_type ----|

| ------------- equalS ------------createIf--------- EXCHRATE_LIST (1st)

"D" ---------------|

(right-click, change @rate_type context to one level higher API_RESPONSE)

@rate_type ----|

| ------------- equalS ------------createIf--------- EXCHRATE_LIST (2nd)

"M" ---------------|

Regards,

Yee Loon

Re: how to create duplicate node at target

yeeloon-khoo — Wed, 06 Jan 2016 07:38:53 GMT

Hi,

and change the EXCHRATE_LIST mentioned by Manoj as well.. you have at least 2, daily n monthy.

Regards,

Yee Loon

Re: how to create duplicate node at target

justin_santhanam — Wed, 06 Jan 2016 07:43:02 GMT

Good catch Manoj.

Thanks,

Justin.

Re: how to create duplicate node at target

Former Member — Wed, 06 Jan 2016 08:44:50 GMT

Actually we have one daily, one Monthly and one is Fiscal Monthly. Fiscal Monthly is replica of Monthly. It is coming with same records of Monthly but we need some calculation based on fiscal month for some fields.

But at target we need 2 ECHANGE_LIST.. fiscal month calculated bid value will move to Monthly EXCHANGE_LIST bid field.

Target is a BAPI, I can not change the occurrence.

Re: how to create duplicate node at target

Former Member — Wed, 06 Jan 2016 09:06:47 GMT

it is not working. The occurrence of EXCHANGE_LIST is 1:1. Do I have to create two separate mappings - one for Daily and other for Monthly/Fiscal Monthly.

Re: how to create duplicate node at target

manoj_khavatkopp — Wed, 06 Jan 2016 09:39:22 GMT

As this is BAPI you need to ask ABAP team to change the occurrence and then re-import it again.

Re: how to create duplicate node at target

Former Member — Wed, 06 Jan 2016 10:30:09 GMT

ABAP team saying they can not accept two EXCHRATE_LIST tables. But requirement is to send both daily and Monthly data. Do I have to create two mappings.

Re: how to create duplicate node at target

Former Member — Wed, 06 Jan 2016 10:43:09 GMT

yes,Or if the input is same,you can split to two.

Re: how to create duplicate node at target

Former Member — Wed, 06 Jan 2016 13:39:24 GMT

Hi Swapna,

I know ABAP is not accepting multiple ECXHRATE_LIST nodes, i just want to give you the solution as per your original question incase the requirement changes.

Use below UDF to set the occurrence of the target node as explained in below blog.

Excecution Type : Single Values


public String setOccurences(String sourcenode, String monthlyRateExist, Container container)
  throws StreamTransformationException {
  StructureNode node = ((StructureNode) container.getParameter("STRUCTURE_NODE"));
  if (monthlyRateExist.equals("true"))
  node.setOccurences(0, 2);
  else
  node.setOccurences(0, 1);
  return "";
  }

Mapping for EXCHRATE_LIST node:

Mapping Result:

Regards,

Praveen.

Re: how to create duplicate node at target

justin_santhanam — Wed, 06 Jan 2016 17:02:15 GMT

Hi Swapna,

There is no point in duplicating EXCHRATE_LIST if your BAPI is not going to accept it. Instead you can try below (Multimapping).

Change the occurrence of BAPI (to make it as multiple message)

Now duplicate the BAPI Message

For the first BAPI Message Node , map a constant(this is for DAILY, and I assume "DAILY" Rate type will definitely be there)

For the second BAPI Message Node , map as following (this is for MONTHLY, and I assume "MONTHLY" Rate type may or may not be there)

UDF for generating second BAPI node

That's it. .. But remember we have mapped only the message level. You need to take care of the context inside the mapping to map the corresponding DAILY and MONTHLY data to the corresponding target messages.

Let us know if this solves your purpose (I hope it definitely will), then we can take a look at the field level mapping to get this one going!

Thank you,

Justin

Re: how to create duplicate node at target

Former Member — Wed, 06 Jan 2016 23:45:06 GMT

Thanks Justin for your help. I already did the multi mapping and able to generate the second BAPI with out UDF. Facing issue with some field mapping of second BAPI.

There is a Date field coming in Daily node but that is not coming in Monthly API_RESPONSE. But in target Monthly BAPI , I have to sent date field.

I tried using context change, but field not coming, when I am using MapWithDefault it is giving blank value.

Re: how to create duplicate node at target

justin_santhanam — Thu, 07 Jan 2016 00:55:21 GMT

Great to hear Swapna. For the field mapping issue, can you please give the sample source xml and how would you want to see it in the BAPI?

It will help to give proper inputs.

Thanks!

Re: how to create duplicate node at target

Former Member — Thu, 07 Jan 2016 10:43:22 GMT

thanks Justin. I talked with client on Date field, they told that:

We should use the "end" field from the Fiscal Monthly under the required Handle for the current month.

we will only ever map one Fiscal Monthly set of exchange rates for the current month if and only if the daily "date" is the end of the month. Otherwise, we will not be mapping the Fiscal Monthly values at all. I have done the below mapping:

Date format: YYYY-MM-DD

in fixed value, I have given all month end dates like: 01-31,02-28,03-31..etc. For testing purpose , I have used constant here but I will use Current date. My mapping not working. I changed the context of date but no result.

sample file will be like: