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.
I am new to alteryx. I am looking for the operation to be done on my data.
I want to create a new column based on the comparison of data with other rows.
For example: If my data set is:
A B C Start Date End Date
1 2 3 06/17/2017 06/26/2017
1 2 5 06/25/2017 06/28/2017
1 2 7 06/29/2017 06/30/2017
4 5 9 07/01/2017 07/02/2017
I want to create new column for which I will first compare data in Column A and B.
If data in current record is equal to the data in next rows for column A and B (in this case for column A and B, for first row, second and third row matches) then I want to further check for the data in column C which is to be copied in newly created column.
This part I completed using Sort and Multiple row tool.
In case of multiple rows with same data for A and B,pick the value of C for the row with the earliest date and Start Date of the next row should be greater than End Date of the current row. (if we can use something like loop, where I will exclude data in C if that row's start date is less than the current rows end date)
So I have to create the new column(Forward_C) in which I will have forward values(next rows) of C.
A B C Start Date End Date Forward_C
1 2 3 06/17/2017 06/26/2017 7
1 2 5 06/25/2017 06/28/2017 7
1 2 7 06/29/2017 06/30/2017 <Blank>
4 5 9 07/01/2017 07/02/2017 (Compare first column A and B with next rows, if they are equal take value of C in Forward_C)
Please let me know if this operation is possible in Alteryx.