Compare Row data with Header names

Question

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 :)

DawnDuong · Answer

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).

ReconCheck.yxmd

lbardoe · Answer

You could just slimplify to the attached image

image.png

binu_acs · Answer

@mrodrigo one way of doing this

CheckingValue_280623.yxmd