Merge the data in a file

Seven Stars

Merge the data in a file

Hi,

 

Could you please suggest appropriate solution for the issue attached.

@TRF has mentioned that there is a simplest approach to restore the alternation.

 

Thanks


Accepted Solutions

Re: Merge the data in a file

Hey vidya,

 

1.) good description have your challange, helps other to help you.

2.)If you started the conversation elsewhere and start of here ... not a good practise

 

Your sample text does not merge the data. The output clearly shows you do filter based on content.

Input
entree dans preocess_bblng|79321|79321|$bllngdtl:cp_billing_dtl$1grGy
entree dans camm_prem_scheduler , Para|79349|79321|-1
entree dans preocess_bblng|79321|79321|$bllngdtl:cp_billing_dtl$1iH68
entree dans camm_prem_scheduler , Para|79315|79321|-1
entree dans camm_prem_scheduler , Para|79343|79321|-1
entree dans camm_prem_scheduler , Para|79374|79321|-1
entree dans preocess_bblng|79321|79321|$bllngdtl:cp_billing_dtl$tQF1
entree dans camm_prem_scheduler , Para|79373|79321|-1
entree dans preocess_bblng|79321|79321|$bllngdtl:cp_billing_dtl$wYTv
entree dans camm_prem_scheduler , Para|79358|79321|-1

Output
$bllngdtl:cp_billing_dtl$1grGy|79349
$bllngdtl:cp_billing_dtl$1iH68|79315
$bllngdtl:cp_billing_dtl$1iH68|79343
$bllngdtl:cp_billing_dtl$1iH68|79374
$bllngdtl:cp_billing_dtl$tQF1|79373
$bllngdtl:cp_billing_dtl$wYTv|79358

... Solution : Use a filter in a tmap or a tfilterrow

 

BR Bp


All Replies

Re: Merge the data in a file

Hey vidya,

 

1.) good description have your challange, helps other to help you.

2.)If you started the conversation elsewhere and start of here ... not a good practise

 

Your sample text does not merge the data. The output clearly shows you do filter based on content.

Input
entree dans preocess_bblng|79321|79321|$bllngdtl:cp_billing_dtl$1grGy
entree dans camm_prem_scheduler , Para|79349|79321|-1
entree dans preocess_bblng|79321|79321|$bllngdtl:cp_billing_dtl$1iH68
entree dans camm_prem_scheduler , Para|79315|79321|-1
entree dans camm_prem_scheduler , Para|79343|79321|-1
entree dans camm_prem_scheduler , Para|79374|79321|-1
entree dans preocess_bblng|79321|79321|$bllngdtl:cp_billing_dtl$tQF1
entree dans camm_prem_scheduler , Para|79373|79321|-1
entree dans preocess_bblng|79321|79321|$bllngdtl:cp_billing_dtl$wYTv
entree dans camm_prem_scheduler , Para|79358|79321|-1

Output
$bllngdtl:cp_billing_dtl$1grGy|79349
$bllngdtl:cp_billing_dtl$1iH68|79315
$bllngdtl:cp_billing_dtl$1iH68|79343
$bllngdtl:cp_billing_dtl$1iH68|79374
$bllngdtl:cp_billing_dtl$tQF1|79373
$bllngdtl:cp_billing_dtl$wYTv|79358

... Solution : Use a filter in a tmap or a tfilterrow

 

BR Bp

Seven Stars

Re: Merge the data in a file

Thanks Bellis...

My Apologies, i was actually suggested to raise a new topic..:-)

Yes, I have found the solution based on the content...