cancel
Showing results for 
Search instead for 
Did you mean: 

mapping source field from look up

Former Member
0 Kudos

hello i have couple of questions and I am on Pi 7.0 and using jdbc lookup on sql table

1.can i map to a different source field from look up from one source field?

eg my source fields are S1 , S2 ,S3 ,S4 ,S5 S6 and i want to populate S4 from S1 and map it to target feld say T4.

I will be adding S1 S2 S3 S4 S5 S6 to target field T4.

lookup based on S1 on dbtable and get value into S4 and map T4 to target field?

is it possible ..any hints ...?

2.can i do look up twice on sql table using jdbc look up .

one call based on S1 and get S4 and S5 from table1 and map it to T4( T4 is always concat S1,2,3,4,5,6)

other call basd on S1 and get count S6 from table2 and map it to T4

thanks for reading

Accepted Solutions (1)

Accepted Solutions (1)

prateek
Active Contributor
0 Kudos

1.can i map to a different source field from look up from one source field?

No.

i want to populate S4 from S1 and map it to target feld say T4.

If S4 is source field, then this is not possible. Map the values directly to target field. Or you may use the output of lookup UDF and use some funcitons further.

2.can i do look up twice on sql table using jdbc look up .

Yes, but that would mean multiple calls to JDBC table for each set of records. Make sure that there are no frequent calls otherwise it would hamper the scenario performance.

Regards,

Prateek

Answers (1)

Answers (1)

Former Member
0 Kudos

Points awarded and marked as answered.

thank you