DSXchange

Sure Criag

Sure Ray. I will try the same.

Thanks,
John :)

Hi Ray, I tried your solution. i was able to read the input file as Single Varchar column and able to store the column heading and positions into stage variables. After that i stuck to proceed further (on how to iterate through all the rows and direct column appropriately onto to the output using Fi...

Hi Abhilash, I tried your solution. If the input file column header order and the schema file column order are same then only its processing the input file and loading the data into output file. Could you please help me on the details how i can reorder the columns with this approach? Thanks in advan...

Thanks for your reply...

Yes. All the input files have column headings.


Please let me know how to approach/solution on this......

Hi, I have a requirement like there will be set of input .txt files with same set of columns but columns order will be different in each input .txt file. I need to create one reusable job to convert the columns order into one particular column order for all the input .txt files. For Ex: I/P: 1st Inp...