There are so many document editing tools on the market, but only a few are suitable for all file types. Some tools are, on the other hand, versatile yet burdensome to work with. DocHub provides the solution to these challenges with its cloud-based editor. It offers robust functionalities that allow you to accomplish your document management tasks effectively. If you need to quickly Omit phrase in VIA, DocHub is the perfect choice for you!
Our process is extremely simple: you upload your VIA file to our editor → it instantly transforms it to an editable format → you apply all necessary changes and professionally update it. You only need a couple of moments to get your paperwork done.
When all adjustments are applied, you can turn your paperwork into a reusable template. You simply need to go to our editor’s left-side Menu and click on Actions → Convert to Template. You’ll locate your paperwork stored in a separate folder in your Dashboard, saving you time the next time you need the same template. Try out DocHub today!
[Music] so go to mappings create remove duplicates okay go to the sources here ill take the employees table which is obviously relational right now i can do the source qualifier example i can use the source qualifier to remove the duplicates using the select distinct or the query itself as ive mentioned earlier lets assume in this case you have to do some validations and you have an expression transformation here assume we do certain validations here right now we are not doing it but assume we have done it so for the example which im going to show you on how to use expression transformation to remove duplicates we need to have the data sorted now that sorting of data can be done here using the override query select all order by descending or ascending whatever is your requirement lets also put the column name here which is one which is nothing but the employee id that is a possibility so you can do it here which is obviously faster but for the sake of our example lets use the sor