I'm curious what happens to the temporary table of a query, when there is another query in the pipe: I have a query (Q1) that has its results in a temporary table (T1).The flow then continues to another query (Q2) that is NOT quering the T1 or even same dimension as T1, it's a completely new, separa...

Here's my final code just as an full example, I'm not a "proper" coder so it might not be the prettiest and there are some "cleaning" possible and the columns had 2 values I didn't want to put in the enumerator, so I rather crudely omitted them with two if/else clauses... but anyway:

I have a file import that has x-number of columns. I want to create an automated enumerator that updates it's values based on the column-labels of the import files.But in order to do that, I need to transpose the column lables of the import file to values of a single column.So - f.ex. the file looks...