Hi,
I want to do automation using studio x community. I want to read text file n to convert the text file into excel file
I have done use excel file activity then
Read text file - i have put the text file folder
Generate data table- how i need to put into the input?
I have run but the text file input do not appear in my excel file
Do u have any idea what i need to choose in option? Because my data file that being converted to excel a bit different as i want the data to be same as in my text file
To add, my column also not in a right way. Meaning that in one column there is two things. During my manual using excel, im using text import wizard before convert into excel
Hi, i already succeed in to convert text file to excel using studio x. But after i try to run, there is a few data that not the same as i do it manually using excel. Firstly, the first 3 data is combine into 1 column. Second is suddenly there is 3 column added
During the manual, i use fixed width. Do u have any idea on how i want the text file to be converted into excel more good? Because i want to cut the step. I know that i can combine the column but more prefer to just have the output like i done manually using fixed width
This is what happen in my output please refer to the image