https://api.xyz.com/1111/details.json (where 1111 is the id and being iterated) which is giving me three columns after extracting the data using textractjsonfields. In the same flow I am calling another api like https://api.xyz.com/1111/comments.json which after parsing is giving me one column. Hence, I need to merge all this columns into an CSV file and then email it.
As part of the solution I have used a treplicate component so that i can replicate the previously generated columns and merge it into a tMap but that is not happening. Please suggest a way for the same. Please have a look on the flow
Read the data from your first API call into a tHashOuput. Do the same with your second API call (a different tHashOutput). Then use two tHashInput components to join the data using a tMap.
I tried to separate the two flows and cache the data using thashoutput but still I am unable to figure out why the data from two different api calls are not getting merged. please have a look on the screen shot.
The requirement is I need to combine 4 columns in one csv file. Out of which three columns are coming from one response. The data is getting referenced from tJavaRow_1 and the last one is coming from another response which is getting referenced from tjavarow_2. Now the csv file should be like this mentioned below
RollNo|Name|Age|Educational Qualification
10|Ajit|24|B.Tech
Now from this the 1st three columns are coming from 1st API call and the last one is coming from 2nd API call. I have divided the flow into two sections but still I am unable to merge the result. I am uploading my job design. Please suggest on the same.
It will be helpful if you can provide a screen shot of the resolution
