Ask Your Question
0

How to Join HTTP client Origin and Http client Processor data.

asked 2018-06-26 06:52:54 -0600

Kumar gravatar image

I have two APIs which gives two tables data. I am getting those two apis data with Http Origin and Http Client, Now i want Join those two apis data with a column column. How can I achieve this. --Thanks

edit retag flag offensive close merge delete

Comments

Please provide more details -- what does your pipeline look like? what's your destination? what format is the data coming in and stored as? etc.

iamontheinet gravatar imageiamontheinet ( 2018-06-26 10:55:34 -0600 )edit

The data is getting in CSV format. The data looks like below, API One PNAME PID ABC 1 DEF 2 API Two VALUE PID 111 1 222 2 Need to join two apis data with PID as join column

Kumar gravatar imageKumar ( 2018-06-27 00:05:34 -0600 )edit

1 Answer

Sort by ยป oldest newest most voted
1

answered 2018-06-27 18:30:33 -0600

iamontheinet gravatar image

I'd suggest you create two pipelines and store the data into a database (for example) using JDBC Producer destination and then perform joins.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-06-26 06:52:54 -0600

Seen: 61 times

Last updated: Jun 26