Forum Discussion
How to hide/remove duplicates based on condition
I'm guessing that it eliminated duplicates for each file individually but there were duplicates across files. I guess you do have to de-duplicate after combining the files then.
In this case, you use the same code (with any step references adjusted, e.g. #"Merge Columns" --> #"Inserted Merged Column") but put it at the end of the FreightForward v2 query rather than the Transform Files (2) function.
If you're going to use a database eventually, you might want to try approach #4 from my blog post.
OK. Then you can either do the manual merge in the transform before referencing it or else do all of the logic in the big query rather than the function component.
Hi AlexisOlson , I tried option 3 by doing all of the logic in the big query but its still processing the first step "Group by" for over 30min now and still going...
Can you please provide screenshots of the code and the exact steps using the function component method so we can save time?
I tried manually adding merge step in function component but kept getting same error i.e. "[JobID+Ticket] column not found"...