cancel
Showing results for 
Search instead for 
Did you mean: 

mapping issues

Former Member
0 Kudos

Hi,

my source structure is like this:

<Category CategoryType="">

<ProductQuantity>

</ProductQuantity>

<DateTimeInformation>

<DateTime DateTimeQualifier=""/>

<DateTimeRange>

<FromDateTime/>

<ToDateTime/>

</DateTimeRange>

</DateTimeInformation>

</Category>

<DateTime><DateTimeRange> this two tags, everytime we can have only one of them.

my target structure is:

<Category CategoryType="">

<ProductQuantity>

</ProductQuantity>

<DateTimeInformation>

<Date/>

</DateTimeInformation>

</Category>

i have two mapping rules, one is if <DateTimeRange> occurs in the source, then split the range into different dates(every Monday), like if range is from 1th june to 19th june, then three dates, 1th june, 8th june, 15th june should be put into the target strucuture in three records.

the second mapping is if AvailabilityClassificationType and Date is exactly the same in source, we add the quantity measurement and put it into one record in target..

can i solve this in graphical mapping? or i need to use UDF?

Thanks a lot

Jessica

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

You will have to create a User Defined function. That is the only answer.

However what you are trying to achieve should really be in the application logic of the sending or receiving system.

My advice is to avoid application logic in Integration and keep the integration clean.

regards,

Advait

Former Member
0 Kudos

Hi,

U can do this using graphical mapping only...no need to use UDF.

Use date functions to spilt date range and node functions to create number of nodes at target side.

regards,

Manisha

Former Member
0 Kudos

you have to use udf.