DataGenX - Atul's Scratchpad

My scrapbook about anything which I learned or want to remember, Sometime about tech tips, thoughts and rambling. If you find anything useful don't forget to give thumbs-up :)

Breaking

Thursday, September 3, 2015

Home / Column / Datastage / design / develop / Scenario / DataStage Scenario #3 - Fetch middle one

DataStage Scenario #3 - Fetch middle one

by on in , , , ,


Develop a DataStage Job to achieve below requirement -




Input:
Single_Column
Atul Kr Singh
Geeta Vishwas
Anoop Despande
Rohit S Pande
Ankit Singh
Garima Bhatia Arya


Output:
Fname   Mname   Lname
Atul       Kr         Singh
Geeta                  Vishwas
Anoop                 Despande
Rohit     S           Pande
Ankit                  Singh
Garima   Bhatia   Arya


For more Scenario -  CLICK HERE





Author Image

About Atul Singh
I am a Data Consultant at a Canadian financial firm. My keen interests varies from Data Analytics, ML, Kubernetes, NLP to ETL. I love to blog and travel in my spare time. If you’d like to get in touch, feel free to say hello through any of the social links.

Related Posts:
By at
Labels: , , , ,

2 comments:

  1. UnknownSeptember 11, 2015 at 11:09 PM

    Use field function in transformer to get the result .
    Derivations in transformer :

    Lname ::If Count(InputCol,' ')=1 Then Field (InputCol,' ',2)
    Else Field (InputCol,' ',3)

    Mname:If Count(InputCol,' ')=1 Then ' ' Else Field (InputCol,' ',2)

    Fname : Field(InputCol,' ',1)

    ReplyDelete

Subscribe to: Post Comments (Atom)

Disclaimer

The postings on this site are my own and don't necessarily represent IBM's or other companies positions, strategies or opinions. All content provided on this blog is for informational purposes and knowledge sharing only.
The owner of this blog makes no representations as to the accuracy or completeness of any information on this site or found by following any link on this site. The owner will not be liable for any errors or omissions in this information nor for the availability of this information. The owner will not be liable for any losses, injuries, or damages from the display or use of his information.