topic Re: Compare Row data with Header names in Alteryx Designer Desktop Discussions

Compare Row data with Header names

mrodrigo — Wed, 28 Jun 2023 09:40:01 GMT

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

Re: Compare Row data with Header names

binu_acs — Wed, 28 Jun 2023 09:57:42 GMT

@mrodrigo one way of doing this

Re: Compare Row data with Header names

lbardoe — Wed, 28 Jun 2023 10:57:21 GMT

You could just slimplify to the attached image

Re: Compare Row data with Header names

DawnDuong — Wed, 28 Jun 2023 12:20:53 GMT

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