Expert tips documentation

We recommend reading through the ‘expert tips’ in the help, if you haven’t done so already.

Windows: Expert tips > Expert tips
Mac: Expert tips > Expert tips

Is there anything obvious we missed from these tips?

Hi,

just one addition to

  1. Use Note items to remind yourself how a complex .transform works.

I use in addition (the notes are very important) intensively the Comment part in the transaction itself

I helps later on in detail to understand what was done some weeks ago, e.g. I describe there which fields are used by the transaction and why some logic is used. And it helps me with the detailed information to solve issues when I due to changes in the input (e.g. changed columns) strange things happens. It requires some discipline but saved me sometimes.

2 Likes

I think subtraction of data set to see what’s been filtered out should be included here !

Anti Join

1 Like