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
Hi @Nithishreddy27 - Can you share some sample data, dummy data would be fine and expected result?
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
hi ADN good job!!!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.