How do I check for a column in an input spreadsheet in non-Orchestrator RE Framework?

Help Studio
1

Hello,

I am using a spreadsheet sent to me from another department as the input for a RE Framework bot.
Sometimes the other department fails to include the phone number column in the spreadsheet.

If the phone number column exists, I will have the bot input the provided phone number into the browser field. If not, the bot will enter a default (999) 999-9999.

Outside of RE Framework, I did this with an If condition of ‘InvoiceTable.Columns.Contains(“PhoneNumber1”)’.
InvoiceTable was the name of the data table.
How do I check the transaction data to see if it contains the PhoneNumber1 item now that I’m not using a data table?
I am not using Orchestrator for this bot.

Your assistance is greatly appreciated!
Dale Corley

2

Hi @Dale_Corley

Welcome to forum

You can use the same condition
‘InvoiceTable.Columns.Contains(“PhoneNumber1”)’.

with little modifications.

Like in reframework when u read the excel file it is stored in TransactionData varaible which is of datatable type.

so u can use the condition before typing phone number in input field as

‘TransactionData.Columns.Contains(“PhoneNumber1”)’.

Then in then and else condition do.it Accordingly

Hope it helps you

Regards

Nived N :robot:

Happy Automation

3

That’s exactly what I needed!

Thank you, Nived N!

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.