When you run tasks, you may have data extracted to the wrong columns or not being extracted at all. This is likely due to incorrect XPath failing to locate the correct data and extract it.
Here’s an example of data fetched to the incorrect data fields.
Here is the data we need:
Here is the data output - note that the highlighted data is not being extracted correctly:
How to fix it?
To ensure that data will always be extracted correctly to the corresponding data fields, you need to write a new XPath that will always pinpoint the right data on all pages. To do this, refer to our tutorial on how to write an XPath. Alternatively, if you are extracting name-value pairs, check out how to associate data with nearby text.
Once you have the new XPath, follow the steps below to update the XPath.
STEP 1. Select the data field that needs to be fixed and select Customize XPath
STEP 2. Enter the new XPath and Apply the setting
In some cases, we might find that data can be extracted in the Data Preview but not so after we run the task, then we can try: