on 04-04-2016 9:02 AM
Hi All,
I have one requirement where I need to split the records based on field how can I achieve this requirement
example :
input : A B C D
x 1 y z
z 2 z z
z 3 z z
x 1 x w
x 1 x X
y 2 z z
If B=1 then i need to pass all the records of the column
if B=2 then i need to pass all the records of the column
if B= other than 1,2 then i suppress the records in mapping level
it should generate 2 output files for when B=1 and B=2
output(B=1): x 1 y z
x 1 x w
x 1 x X
output(B=2): z 2 z z
y 2 z z
note: file will contain records of B=1 and B=2 and other than this values also .
Please Help on this Requirement
Regards
Umesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Praveen ,
Now is ESR part is complete ,coming to ID Part how maintain FCC parameter for that structure,
Present I am Configuring FCC with Message type when I take the payload that structure is relate to Sender Message but in Message Mapping Structure is different bcz of target occurrence 0-unbound .
Is there any parameters is need to add in FCC?
Regards
Umesh
Thanks praveen now I can two message in receiver folder .its authentication problem
More question can I do dynamic configuration for time stamp ?
if yes please give me some inputs, to which root node I need to map (Dynamic timestamp UDF)
I tried with udf mapping to top node of receiver data type which is 'message'
but one poll interval its is generating one output file ,message log it showing two fine are generated .with out dynamic time stamp its working fine .
please suggest me
Regards
Umesh
but we have separate time stamp formate that's why I am using dynamic time stamp .
if I use Dynamic I am not getting two file.
if I use add time stamp to file name check box in the SFTP receiver channel,I am getting two file
File formate is : filename.yyyymmdd.pay001.txt
Can you help me ?
Regards
Umesh
User | Count |
---|---|
80 | |
9 | |
9 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.