Hi team, facing problem in middle of workflow and the problem is i have to use expression with unique rows and lag column(i mean -1 row. ) so basically i have scenario where some data has duplicate value but with unique identifier ( there are also duplicates also with unique ids) and i have to merge two column before grouping it to get unique data and than i have to use some expression like:- {IIF(isnull([Row-1:RecordID]), 1,[Row-1:RecordID]+1)} i had used lagged function to get -1 records and the problem is lagged worked for all the records so i have used chunk loop and lagged function to get -1 record for specific groups and column expression for condition. now the problem is, i have some where around 70K groups and i can use only 1 chuck row for specific groups. so for 70K it will take around 2chatr0 hours. 1 record 1 sec. is there any other option i can go with

multi row formula

ArjenEX January 25, 2023, 7:38am 4

Multi row Alteryx to KNIME conversion was mentioned on the forum some time ago as well.

Maybe this already helps you further and otherwise indeed a sample with input and expected output.

1 Like