Post reply

How to change the sequence of source column

  • November 3, 2015 at 12:50 am

    #399268

    Hi All,

    I am working on 1 POC project.

    I have 2 customer having source file in txt format, but the column sequence of both customer are different.

    Number of column in all the files are same

    like below.

    CustA

    ID NAME AGE

    1 VIPIN 29

    CustB

    ID AGE NAME

    2 29 jayesh

    As per source file you can see that CustA have column sequence ID,NAME,AGE and CustB HAVE ID,AGE,NAME sequence .

    I have target table #Temp with ID,NAME,AGE sequence.

    Like that I have many files from both customer, I have to load in ID,NAME,AGE sequence from all source file to target table.

    How can we change the sequence of source column before loading to target table

  • November 3, 2015 at 1:20 am

    #1837274

    vipin_jha123 (11/3/2015)

    Hi All,

    I am working on 1 POC project.

    I have 2 customer having source file in txt format, but the column sequence of both customer are different.

    Number of column in all the files are same

    like below.

    CustA

    ID NAME AGE

    1 VIPIN 29

    CustB

    ID AGE NAME

    2 29 jayesh

    As per source file you can see that CustA have column sequence ID,NAME,AGE and CustB HAVE ID,AGE,NAME sequence .

    I have target table #Temp with ID,NAME,AGE sequence.

    Like that I have many files from both customer, I have to load in ID,NAME,AGE sequence from all source file to target table.

    How can we change the sequence of source column before loading to target table

    Without editing the file, I don't see how you can.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply