Hello, I am trying to perform multiple actions on an Excel, but it’s not working for me. Here is what I’m trying to do:
Delete unwanted columns
Keep only 2 columns
Filter 1 of those 2 columns that I kept
So there are columns on my excel listed A thru Z. I want to delete all of these except Columns J & S. and then on Colum J, I want to filter only certain functions to appear. I am trying to figure out if I should do the filtering part first, or should I do the deletion first? I understand if I do the deletion first, Columns J & S would no longer be Columns J & S, I guess they would be become A & B?
Any guidance would be great, please note I have had no training on StudioX, and would greatly appreciate step by step instruction with screenshots on how to execute the asks above, TY!
To Delete unwanted columns, use this activity where u can mention the columns to be deleted
For example, you can enter the following from the Text Builder:
Ok just so I’m clear, Colum name means the actual name of the column? Or is it asking for the column letter? i double checked the name and it is correct no spaces no misspellings. and the column letter is J… so am i supposed to put the name or the letter for the column? I should have asked that in the beginning also there’s 2 columns that need not just one
so once the bot is done (this was before i got the column name error message) it would say last run successful. However, when the website downloads and sports the excel, ALL the columns are still there lol it doesn’t execute my command of deleting those specific columns. So this is what it looks like when the bot says its successful (cells blacked out for privacy)
ok so i disabled the filter activity and just ran it with just the delete activity, and its not deleting anything. when the download happens, and excel pops up, totally blank, and on the top it says saving… and then that blank excel goes away and the actual excel download opens up looking like normal, with all the columns still intact, nothing is deleted. this is how i have it right now
this is what i have, but maybe i’m not understanding the fields… does excel file mean the actual download from the website? and the “reference as” field, is that just what i’m calling the download? and does source mean the actual excel? or the tab within the excel i am working in? also how do you have your configure filter set up?
When you say “sheetname” do you mean the excel itself? or the name of the tab within the excel that i am working off of? because the name of the excel itself is EPIC 2.0 - Audit Detail - Proactive Audit.
and the name of the tab that i am working off of is Excel View.
Theres only one excel that i would be working off of which is the one that gets downloaded from the website and saved to my documents, which is the file called EPIC 2.0 - Audit Detail - Proactive Audit. so i dont know what you mean by “are you checking the right file you used in the use excel”