How to compare two columns of one variable-table?

variables

#1

Hello,

I am copying a table from Excel to a table-variable called “kbl_table”. Thereafter I want to compare the columns 2 and 4 of the “kbl_table”. If they are identical nothing should happen, if they are different the respective row from the “kbl_table” should be written to the “mismatches” table-variable.

Apparently I am doing something wrong, but I have no idea what… I searched the Workfusion forums and Google, but without success :-/

Thanks in advance


#2

@Bernd_Heberer,

Thanks for your interesting case!

Here is how you can solve it:

table-columns-compare.zip (2.5 KB)

It is not very simple solution, but it is a working one.

We are planning to introduce Indexes for Tables and Lists in future releases to do this operation in one line, something like:

${my_table[1][2] != ${my_table[1][4]}}

Please vote for this feature to help us prioritize. Thanks.


Problem in reading Table variable
Extract data from one Excel data table to another
Table Content Exception Reporting
#3

That is great ! You are a genius, thank you so much :star_struck: