I have a question
i have few csv file in my server and the columns changes very day and file to file.
like for example for invoice1.csv columns are:
Invoice number, customer_id, Valid_from, Valid_to, extraction_time,user_code,emp_id
and second file invoice2.csv columns are:
extraction_time,user_code,emp_id,Invoice number,customer_id, Valid_from, Valid_to.
And i need the file to be some order like:
Invoice number, customer_id,user_code,Valid_from, Valid_to,extraction_time,
emp_id. for datastage or lets say the order in which i want the columns to be.
Can Any one suggest me an idea
![Idea :idea:](./images/smilies/icon_idea.gif)