I have an url which is like below where xyz is the input value(there will multiple values from the db) to be passed for every number and output is in the form of xml
I need to get output of col2 only and use it to filter out those not required
please help me what components i have to use it
Solved! Go to Solution.
Follow the below steps.
Read xyz values from source
Pass xyz and url to httpRequest component and get xml file.
Use tExtractXMLField component to respective required fields form xml
Use tFilterRow/tMap to filter unwanted records and load data to target.
i have done steps you mentioned
source-->thttprequest (here for testing i checked the "write content to file" and was able to see xml file)
but i dont know how to configure the tExtractXML component
<?xml version="1.0" encoding="UTF-8"?>
I am reading multiple rows from the source but it extracts only one row .. basically i need to get all those rows that matches the filter condition