Union from different inputs removing duplicate values

[laisvarotto]

Hi,

I am using the union tool to combine a few inputs but I didn't want to bring all the rows, each of my files are from different months for example:

August's file is from 15/08 to 30/09, September's file is from 16/09 to 30/10 (with multiple rows for each date)

when combining the two files I want to only keep the lines from the latest file for the same date so in this case from August file I'd have data from 15/08 to 15/09

This's how the raw data looks like:

Many thanks!

[Sebastiaandb · Accepted solution]

Hi @laisvarotto,

For what you want to achieve the simple method would be to join both files by the "created on" file. Thereby for example the R input is august and the L input is September and you only take the R output from the join for the august data. thereafter you'll do the union with September. In case you have way more files it would be better to built a macro for this but that might not be convenient for just having simple oversight of the workflow.

Greetings,

Sebastiaan

[laisvarotto]

Perfect, thank you @Sebastiaandb!

[Sebastiaandb]

Hi @laisvarotto , Glad to be of help!