Facing issue in Generating data table actvity while using fixed width columns

Requirement : Need to convert text file into xls file
also need fixed width coluimn like “Created case”

For that i am doing

  1. Read text file taking output into InputTextfile
  2. Using Generate data table from options tab when I am selecting fixed width option from data formatting
  3. Then using filter data table activity in it giving “Created case” is not empty
  4. Write range activity to output file…

Output is not coming as expected ,

can anybody give the solution to above issue.

Thanks in Advance !!

Hi @mittal.abhishek066 ,

Can you share a sample text file and output file how you need?

Hi @Manish540 Due to security policy can’t share the file on the basis of created case in text file then need to find in excel file for that i am using the same logic which is mentioned above also if u have your understnading and idea about how to give fixed width value then mention here i will let you know whether it’s working or not…

Thanks…

@mittal.abhishek066

Basically you need to count the number of charqcters and gice the values of the width for each column…

And would suggest use log messages or use debug mode with step into and check after each strp if data is coming or not…so that you can identify where the error is first

Cheers