i need to take table data from Text file and want to write this data into excel? help me out
If the table in input file having same number of columns always then use Text file input step and choose the ‘Filetype’ as “Fixed” in Content section.
After this in Fields section, Click on Get fields, mark your columns as per need and add fields.
