Hi @Lavanya Anbuselvan ,
Would you be able to share the screen shot of the table here?
Please find the below
IQ Bot 11.x: Table fields - Automation Anywhere Documentation
IQ Bot 11.x: Map a table - Automation Anywhere Documentation
Could you please explain the below code.
# convert from dictionary to dataframe
df = pd.DataFrame.from_dict(table_values)
# print dataframe before update
# Item_Description: drop rows with a missing value
df = df[(df["Item_Description"] != "")]
# Quantity: extract first part of the string, the numeric part only
df['Quantity'] = df['Quantity'].str.split(' ', 1).str.str.strip()
# print dataframe after update
# convert back from dataframe to dict to override what IQ Bot stores
table_values = df.to_dict()
I am fetting error as "nameError : name 'table_values' is not defined : File "<string>", line 3, in <module>\n'"
Can you please share it code with the IQ BOT logic screen and Error?
Please try the below code
import pandas as pd
My Issues is that rows are overlapping
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.