Help in script

Flow Classic
1

HI All,

I’m stuck in teh belwo scripting, it would be great if someone can help me in this.

I have 2 connectors to fetch data from 2 system and they belong to separate DB.

connector 1 gives me list of values as below

val1,val2,val3,val4,val5,val6

Connector 2 takes value from above and store in a table.

So lets say at present connector 2 select is giving me data val5,val6

So I need to know who can write a script so that connector 1 doesn’t dhow val5,val6 as it’s alreathy there in database.

BR,

Bhaski

2

Hi, FlowScript behaves differently between Classic and Connect, so I’m honestly confused about which functions work where. But I have some examples in a classic workflow which might help you:

Example 1:
let usr = [name: “bob”, id: 45, orgid: 1001]
& [name: “bill”, id: 46, orgid: 1002]
& [name: “joe”, id: 47, orgid: 1002]
& [name: “joe”, id: 47, orgid: 1004]; // this org does not exist

let org = [orgname: “Ikea”, id: 1001]
& [orgname: “Novacura”, id: 1002]
& [orgname: “Flowington”, id: 1003]; //This org has no users

let LeftJoin = select name, id, firstOrEmpty(org where id = orgid).orgname as orgname, orgid from usr;

let usersWithoutOrg = usr where not any(org where id = orgid);
let usersWithtOrg = usr where any(org where id = orgid);

return LeftJoin;
//return usersWithoutOrg;

Example 2:
let usr = [name: “bob”, id: 45, orgid: 1001]
& [name: “bill”, id: 46, orgid: 1002]
& [name: “joe”, id: 47, orgid: 1002]
& [name: “Anna”, id: 47, orgid: 1004]; // this org does not exist

let org = [orgname: “Ikea”, id: 1001]
& [orgname: “Novacura”, id: 1002]
& [orgname: “Flowington”, id: 1003]; //This org has no users

let usersWithOrg = usr where any(org where id = orgid);
let usersWithoutOrg = usr where not any(org where id = orgid);

return usersWithoutOrg;

3

Hi Ola,

Thanks for the quick response and help.

I’m using flow classic, and it’s working for me.

Many thanks.