Flow Data Source with Custom Object

Unknown

Flow Data Source with Custom Object

Unknown

I have multiple data objects that i need to combine parts of in a Flow Data Source to show the correct report. Is it possible to create the data source in the flow, populate it, and then return it to the report? I do not want to have to create a defined data structure for each report, i would like to generate them on the fly.
[i]edited by christopher_salas on 5/13/2020[/i]

Unknown

Hi Chris,

Unfortunately, Report Data Source Flow only accepts one outcome data as an outcome scenario. The only way is to combine different data objects in the flow into a single data object and map it to flow outcome. Please check the attached document for more info.

Regards

[url=https://documentation.decisions.com/docs/using-flow-source-report]https://documentation.decisions.com/docs/using-flow-source-report[/url]

Unknown

Hi Chris,

You cant map two separate objects as report source into a single report, but you can combine two objects by using Raw SQL Step and Flow Structure together. I have attached an example. In the example, two separate objects FirstName and LastName (simple data structure) are joined on FullName joint object (simple flow structure - not database stored). You can run Create Sample Data flow first to generate data.

In your case, you also need to map this joint object to your Report Data Source Flow output as mentioned in the document. Please import and check the example. If you have any question please let me know.

Regards