You need to output only a list of field names, arranged in a single column, for a reporting function. You have already imported the data using a Database node and know it has 25,000 records. Which…

Question

Options

• ADatabase > Filter > Transform > Table
• BDatabase > Transform > Filter > Table
• CDatabase > Filter > Transpose > Table
• DDatabase > Transpose > Filter > Table

• A
  4% (2)
• B
  4% (2)
• C
  84% (41)
• D
  8% (4)

Explanation

Option C is correct because Transpose is the operation that rotates your data structure, turning column headers (field names) into row values - which is exactly how you produce a single-column list of field names. Placing Filter before Transpose is critical with 25,000 records: you reduce the dataset down to just what's needed (e.g., a single row) before the rotation, keeping processing efficient.

Why the distractors fail:

• A & B both use Transform instead of Transpose. Transform modifies cell values or data types but does not pivot column headers into rows, so you'd never get field names as a standalone list.
• D (Transpose > Filter) transposes all 25,000 records first, creating a massive intermediate structure with 25,000 columns before filtering - wasteful and impractical.

Memory tip: Think "Filter then Flip." Always shrink your dataset with Filter before you Transpose (flip) it, so you're only rotating a tiny slice rather than thousands of rows. If you need column names as data, you need a Transpose, not a Transform.

No community discussion yet for this question.