Forum Discussion

gmoore7's avatar
gmoore7
Frequent Visitor
2 years ago
Solved

Dataflow Gen2 Max Effective Date as Parameter

Hi, I have a Dataflow Gen2 where I am first querying the Max Effective Date from a table and then trying to use that as a parameter in a query later on in the flow (see screenshot).   I am running...
Dataflows
Need Help
  • miguel's avatar
    miguel
    2 years ago

    Hi!

    Is your first query being staged or not? If it set to be staged then that might be causing an issue as only tables can be staged and scalar values (like the one from a List.Max) will yield an error.

     

    You can either set your first query to not be staged or change some components of your query so that the aggregation is perhaps done with a Group by and then you do a drill down in the second query to the Max value that you're looking for from the field that you require.

miguel's avatar
miguel
Icon for Community Admin rankCommunity Admin
2 years ago

Hi!

Is your first query being staged or not? If it set to be staged then that might be causing an issue as only tables can be staged and scalar values (like the one from a List.Max) will yield an error.

 

You can either set your first query to not be staged or change some components of your query so that the aggregation is perhaps done with a Group by and then you do a drill down in the second query to the Max value that you're looking for from the field that you require.