Suljettu

Informatica

I have this expression

(IIF(LTRIM(RTRIM(SUBSTR(HEADER_INFO,2,13)))='',NULL,LTRIM(RTRIM(SUBSTR(HEADER_INFO,2,13)))))

for the sample data below, but it is failing when it finds more than one D records after the H record.

My goal is to have an expression that if it sees multiple D records after the H record, it reads those records as well, and if only one D record, it reads that record and move to the next H record.

Right now, it is failing because it is expecting an H record after each D record, but there are situations as shown below where there are more than one D records after an H record.

HP5919274001273HWA8365C DEFORD DONITA 1245327121 1184950479 6021928 0 20191001201910017 0

D1 D00054317763400

HP2519274011110HWA8365C DEFORD DONITA 1245327121 1184950479 6021928 0 20191001201910017 0

D1 P00054317763400

HQ2519280005752HWA8365C DEFORD DONITA 1245327121 1184950479 6022011 0 201910072019100710 0

D1 P49348004537100

D2 P49348015339100

D3 P00054350049100

HQ2519289004679HWA8365C DEFORD DONITA 1245327121 1184950479 6022011 1 201910072019101610 0

D1 P49348004537100

D2 P49348015339100

D3 P00054350049100

HP2519309005224HWA8365C DEFORD DONITA 1245327121 1184950479 2012699 0 201911052019110514 0

D1 D00904667840315

HP2519309005132HWA8365C DEFORD DONITA 1245327121 1184950479 2012699 0 201911052019110514 0

Taidot: Informatica Powercenter ETL, Data Integration, tietojenkäsittely, Tietokannan hallinto

Näytä lisää: informatica tool, informatica overview, informatica login, informatica software, informatica etl, informatica tutorial, informatica careers, informatica powercenter, hi hegenabo i noticed your profile and would like to offer you my project we can discuss any details over chat it is editing sho, hi webexpertssss i noticed your profile and would like to offer you my project i have few website correction and reset the pw fo, how can i find peiple like great writer to help me wrute my book, hw can i find a graphic design to do page layout for my mazgine, i always try to understand your needs and often make my own suggestions before starting the project in order to reduce your tota, i am a developer and need a good designer for my app, i am looking for a freelance to make templates for my printing website, i have 300 pdf page that need to retype in text or word formatt i will allow you to work next 6 months in my project i will pay , i need an accountant that won t judge me by my horrible neglect, i need help to have an online platform to sell my designer shirts, i need one internet marketer who can handle this for my website, i need someone to install paid-to-click script in my website

Tietoa työnantajasta:
( 0 arvostelua ) Fresno, United States

Projektin tunnus: #26591426

13 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_18% %project_currencyDetails_sign_sub_19%/tunti tähän työhön

schoudhary1553

Hi, Greetings! ✅checked your project details: Informatica ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking fo Lisää

$20 USD / tunti
(224 arvostelua)
7.7
(171 arvostelua)
7.4
jojimathew571

Hi, I am interested to help solve this issue. Nothing seems wrong with the expression and it should work perfectly fine whether column HEADER_INFO has record starting with D or H; unless the H records are shorter le Lisää

$15 USD / tunti
(2 arvostelua)
2.6
roshvirole

i would help you out to resolve this error to have an expression that if it sees multiple D records after the H record. I have experience in working on excel functions

$20 USD / tunti
(0 arvostelua)
0.0
mrjha93

I am holding around 5 years of working experience of Informatica Power Center with very good analytical skill.

$18 USD / tunti
(0 arvostelua)
0.0
agarwalswathi98

Is there any other data between these H and D records?Because as far as i can see from the example,every line is being processed with LTRIM(RTRIM(SUBSTR(HEADER_INFO,2,13))). I have worked with PC and i have tried the e Lisää

$15 USD / tunti
(0 arvostelua)
0.0
RAJARAM7068

HII I CAN WORK VERY FAST WIRHIN 40 HRS I HAVE BEST KNOWLEDGE IN THIS FIELD ALSO I HAVE MORE THAN 2 YEARS EXPERIENCE IN THIS FIELD SO PLEASE GIVE ME A CHANCE TO WORK

$20 USD / tunti
(0 arvostelua)
0.0
vishnuvardhan299

this expression is for extracting 13 chars, I believe your requirement is to extract that number or ID, if you can explain little about this like what exactly is your requirements I can provide the optimal solution. as Lisää

$22 USD / tunti
(0 arvostelua)
0.4
rpandey85

Hi I saw your issue and will solve this issue . Please let me know for further details discussion so please me in my chat box.

$22 USD / tunti
(0 arvostelua)
0.0
gautamglna

Have realtime experience of 6.6 years in Informatica power center development. Worked alone as well as in team. Lead the project. Having good analytical and logical knowledge.

$15 USD / tunti
(0 arvostelua)
0.0
raghvendramr

I have around 16 years of experience in Informatica powercenter.

$16 USD / tunti
(0 arvostelua)
0.0
venkatabaskar2

I am having around 7 years experience as a Informatica developer. so I can help you to fix the issue you are facing.

$16 USD / tunti
(0 arvostelua)
0.0
bhavyabhardwaj2

I am a senior powercenter developer. and i will be able to fix your problem in less time than expected. Let me know if interested to get your work done. Thanks! Bhavya bhardwaj +919899706730

$20 USD / tunti
(0 arvostelua)
0.0