This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
From the above table. compare the C1 and C2 , if they are equal then particular compared value in C1 must be made 0. for example In C1 I have A and in C2 I have A then C1 contains A made to 0.Is it doable in alteryx.
Thanks for the reply. But my issue is to compare every row of C1 with Every row of C2.From the table am comparing the all the values of C1 with all the values of C2.Then if C1 value exists in C2 then that same value which is equal should be 0 in C1.
It can be done but its much trickier. Here is a way to approach it which is somewhat limited in that it will be very time consuming with a large data set, but will get the job done. See attached for my attempt.