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, separate query, that just is in the same flow.It will
have its results in a new Temporary table (T2). But what exactly happens
to T1? Is it dropped?Does it stay in memory until the whole WF is
stopped?Somet...
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 like this:Column1Column2Column3Column4Column5Data 1Data
2Data 3Data 4Data 5Data 1Data 2Data 3Data 4Data 5Data 1Data 2Data 3Data
4Data 5I want to get this kind of result:Label of ColumnsColumn 1Column...
