on 11-16-2016 6:42 AM
Hello All,
i have urgent requirement , how to spilt payload based on condition in same receiver folder.
I convert Fcc file to xml format. my payload having five fields(emp id,department,designation,experiance,salary) data.based on department field i need to spilt the data.
In Receiver channel how can put folder path for different departments.
ex: departments(Abap,hr,fico,pi) based each department i need to spilt the pyload.
How can put conditon in Receievr communication channel levl.
Please its urgent help me.
Thanks,
s.k.prabhakar.
Hi Prabhakar!
First, you should use split mapping to receive multi-message structure with one message for each of your departments.
Than you can use "Variable Substitution" option on "Advanced" tab: set the name for variable, for example, "fname" and reference to payload value - payload:Message_Name, [index], Element, [index], Element[index],.... , representing the path to element, containing value that you need.
After that, use this variable in file name schema - for example, File_for dep_%fname%.xml
Regards, Evgeniy.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Evgeniy,
I created all senarion but now only pending is spilting payload based on department in same folder only.
I created my Receiver channel variable substitution under Advanced tab like this. I gave here element names is Department Names.
But it is not working here element names means dapartment names or my 5 field names.
Thanks,
No, it defines the element path in structure with needed value
Example:
<MT_Message>
<emp>
<emp_info>
<dep>ABAP</dep>
</emp_info>
</emp>
</MT_Message>
Path:
payload:MT_Message,1,emp,1,emp_info,1,dep,1
It means: first "MT_Message" element, first "emp" element, first "emp_info" element, first "dep" element.
Regards, Evgeniy.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Prabhkar,
Split the file and configure 2 file channels pointing to different files and file names.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Evgeniy,
I am not able to understand what will ido.
This is my input file data.
101 PI Developer 100 4
102 ABAP Developer 100 4
103 PI Developer 300 4
Based on different department i need to spilt payload to different files. I heard we can achive file name runtime by using ASMA PARAMETRS.
How can i configure my receiver channel.
Thanks,
What is your exact requirement?
1. Do you need to place files with same names to different target folders (according to department)?
2. Do you need to place the files to the same folder with different names (according to department)?
3. Do you need to place the files to different folders with different file names?
Regards, Evgeniy.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.