nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Create query based on input data

Hamder83

Hi guys

Im in desperate need of a solution for this.

I have a input file containing:

Customer - Shipment id
Dennis 123456785
Martin 1111122257
Jens 222333564

I want to compare the shipment id to my mysql database

So I would love to be able to do something like

SELECT * FROM
Integration.booking_line bl

where

bl.shipment_awb IN (

[Shipment_id]
)

is this in any way possible?

Database Connection

Accepted answers

RolandSchubert

Hi @Hamder83 ,

double checked it with my database, it seems, concatenation and adding quotes are not needed, as the complete column is used for an "IN" statement. I've modified the sample, hopefully it works now as expected.

Best,

Roland

SelectIN2.yxmd

All comments

RolandSchubert

Hi @Hamder83 ,

it should be possible using the Dynamic Input tool. Create a query as you would do using the Input Data tool in "Input Data Source Template" including the "Where" statement. Modify SQL Statement provides the option to replace your template where clause by the specific list of Ids from your file. This list can be generated using the Summarize tool (concatenate entries).

Let me know if it works for you or if you need more detail.

Best,

Roland

Hamder83

Hi Robert

I dont think i have the knowledge to do that..

May I ask for you to create a super simple flow just with a text input and the dynamic input joined witha db connection?

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15906

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703