I have a dataset that I need to track changes with.
I.e every row should have a date columns that corresponds to when that row was made or changed last.
Can I do this in builder, it is possible in transforms via incremental builds but I would like to stay in builder if possible ?
You can try using the changelog output write mode but this wouldn’t get you the exact date (the changelog calculates it using what number build it was)
Could you maybe have two separate datasets one being the changelog and one being the output and join the changelog onto the actual output to figure out which rows you need to update the date on?