To add, content of the text file is also a number. But a few of string
Hi @Nur_Amin
This is to be done after generate datatable activity
For filtering data in rows. You can use like below . Here the filtering is for rows where the column A is empty .Similarly you can change the condition for your requirement
In the same activity if you already know which columns to remove, then give the column names like below and they will be removed
For removing or deleting column use as below… Here either give the column index or the column name to delete that column(Give only one of those two)
Cheers
Hi @Nur_Amin
pass Read text file output to the generate datatable and give the column and row separators in the properties and give a datatable in output
cheers
Hi @Nur_Amin
No that you are trying to write to file directly…Click on the output field…Delete everything like file(dt) etc and click ctrl+k then write a name…That name is the variable name for your datatable…Ctrl+k automatically creates a variable
cheers
Variable name for my datatable means i just simply name it or how? Because in the output, i need to choose
Hi @Nur_Amin
You dont need to choose…after clicking plus select advanced editor…press ctrl+k and give a name and press enter…a variable gets created… did you get a chance to complete your basic training from academy.uipath.com? If no i would suggest you to do that so that you will get a fair idea to move ahead
Cheers
@Nur_Amin you have to put a datatable variable or create one using ctrl+k
Cheers
How to put data table variable?
I need to do the variable first then generate data table? Or when i drag data table, i click button + then add the variable as u show above?
HI @Nur_Amin
The sheetname that you provided looks more that 31 characters. Make it smaller and this error would stop
cheers