Compare Row data with Header names

[mrodrigo]

Hello Team

I hope all is well :)

I have a question here I am not able to figure out yet.

I have this dataset

I would like to test if the info in the column DataP-Out matches the Headers.

DataP-out is the last Date where we can have amounts.

What i want to is to compare the rows in the DataP-out with the Headers.

If the DataP-out matches the Header and the row is null/empty would show an "OK", else "error".

Unfortunately I have no idea how to manage it.

Could you please assist?

Thanks

Roddy :)

[binuacs]

@mrodrigo one way of doing this

[lbardoe]

You could just slimplify to the attached image

[DawnDuong]

hi @mrodrigo 

If your data is not too large and the number of columns is not crazy, using a combination of Transpose, Filter and Sample will solve it - as shown below.

However, if your data is so large that doing a Transpose does become cumbersome (coz no of rows multiplies by number of columns and the size can blow up!), you can consider modifying the work flow into a batch macro to read through the RecordID one by one (hence this becomes a linear-scale order rather than a ^2 problem).