Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Any idea to turn semi structure to structure data

Any idea to turn semi structure to structure data

New Contributor

Hi all Can you help me share the idea to turn semi structure to structure data 

 

I have Reporting Fixlenght file  like picture below 

 

ask.jpg

 

- I Need to capture  Filed  As of Date (Top header yellow) to every row  

-I need capture Report to (secound line yellow)  to every row  

the final output that i expected  is

 

<as of date>  <Report to> <Customer ID> <Dimension>

27-08-2559        001              S1230               3*10*23

27-08-2559        001              A0711                4*12*17

27-08-2559        001             M2312                5*10*23    

.................         ......              ..........                 ...........

27-08-2559        002              C0048                8*8*22

 

Please Advice  thanks in advance