You might have noticed I used this in the last example. AutoGenerate is so useful and has so many use cases. I probably use this in every app I create: from empty stub tables, generating a new field using another’s unique values, or as a way to log different steps within the load.
What it does is generate a table with the number of rows specified. This means you can create records with theoutput of functions, variables or strings without needing to specify a source.
Here is an example, which includes another tip if you catch it:
Which returns: