Database connect and more than one querry.

Post Reply
Prescott
Newbie
Posts: 6
Joined: Fri Aug 12, 2022 1:03 pm

Database connect and more than one querry.

Post by Prescott »

Hello,
I need more than one SQL selects in one flow. When I put two database connects consecutively, the second override the metadata from the first. Both sql selects are automatically saved into one "LOG" metadata dataset. So how can I save more SQL results into metadata please?

Thanks for advice.
Attachments
Setting element:
Setting element:
setting.PNG (6.33 KiB) Viewed 891 times
Metadata result
Metadata result
metadata.PNG (11.83 KiB) Viewed 891 times
FLOW
FLOW
flow.PNG (6.06 KiB) Viewed 891 times
laurentd
Member
Posts: 137
Joined: Wed Mar 13, 2019 2:06 pm

Re: Database connect and more than one querry.

Post by laurentd »

Use the Data with log connection after each SQL query.
Define different dataset names on the outgoing connections.
Laurent De Wilde, Solution Architect @ Enfocus
Post Reply