I have a table which consists of multiple rows with unique I'd and also unique rows with unique I'ds. I wanted to split these multiple rows with unique I'd into another table. Please help me out

Nithishreddy27 · January 11, 2022, 7:36am

I have a table which consists of multiple rows with unique I’d and also unique rows with unique I’ds. I wanted to split these multiple rows with unique I’d into another table. Please help me out

omprakashjena · January 11, 2022, 10:53am

Hi @Nithishreddy27 - Can you share some sample data, dummy data would be fine and expected result?

Thyme · January 11, 2022, 4:47pm

I made up some data and took a guess on your expected output.
If you have multiple groups of notUnique ID’s, you’ll need the right solution. If not, you can use the left one (probably faster).
If I guessed wrong, please provide more details about your question (as omprakashjena mentioned).

duplicate_split.knwf (41.5 KB)
edit: I forgot to add the other output table in the screenshot. Please imagine a another table that holds Rows 3 to 5, thank you

promanavi · January 14, 2022, 1:17pm

hi ADN good job!!!

system · January 21, 2022, 1:18pm

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.