prioritize recent data for input datasets in dataflows for preview

Options
WHM
WHM Contributor
in SQL Dataflows Ideas

We all run into the situation where we have two tables with hundreds of million of rows and we drop them in the dataflow and know that our join transforms will never match up. Could we get the most recent 10k rows from the input datasets rather than something seemingly random? That would really boost our ability to validate that SQL as we go along.

3
Up
3 votes

Active · Last Updated

Comments

  • DomoDork
    DomoDork Contributor
    Options

    I really need this. It's so hard to validate data without being able to control what records come through in a preview. I also really think a sort tile would be super useful. I realize you can do this with the Rank and Window tile, but dropping in a sort tile would be much simpler.

Categories