Extract Data Table Column is giving empty values

Help Studio
, ,
1

Hi All,

I am trying to extract data table but the first column giving empty values even when there are values.

The image shows a filtered list of sales opportunities with their details and a pop-up preview window summarizing selected opportunities and offering options to export the data as CSV or close the preview. (Captioned by AI)
The image shows a filtered list of sales opportunities with their details and a pop-up preview window summarizing selected opportunities and offering options to export the data as CSV or close the preview. (Captioned by AI)1883×728 67.1 KB

The image shows a data preview window from UiPath, displaying a table with Opportunity IDs, Opportunity Names, and Account Names, next to options for exporting the data and enabling data extraction from multiple pages. (Captioned by AI)
The image shows a data preview window from UiPath, displaying a table with Opportunity IDs, Opportunity Names, and Account Names, next to options for exporting the data and enabling data extraction from multiple pages. (Captioned by AI)963×821 54.9 KB

2

Hi @dutta.marina

Can you provide me the link on which data table is present.

3

Hello @dutta.marina ,
When using Extract Data Table, click on the first-row value of the Opportunity ID column, and when prompted to extract the complete table, select Yes.
If this doesn’t work try to extract just first column separately and then merge it with other data table.

4

@Ankit_Kumar2

Its extracting but when writing to excel, the column gets empty and preview also empty .

The image shows a data extraction preview window for a list of opportunities, including columns for Opportunity ID, Opportunity Name, and Account ID (Name), with an option to export the data as a CSV file. (Captioned by AI)
The image shows a data extraction preview window for a list of opportunities, including columns for Opportunity ID, Opportunity Name, and Account ID (Name), with an option to export the data as a CSV file. (Captioned by AI)667×548 26.7 KB

The image shows an Excel spreadsheet with opportunity-related data, alongside a Table Extraction tool interface displaying the column selections and extraction settings. (Captioned by AI)
The image shows an Excel spreadsheet with opportunity-related data, alongside a Table Extraction tool interface displaying the column selections and extraction settings. (Captioned by AI)1727×821 95.4 KB

The image shows a table extraction tool interface with extracted data fields and a preview of the Opportunities in a Salesforce-like CRM system. (Captioned by AI)
The image shows a table extraction tool interface with extracted data fields and a preview of the Opportunities in a Salesforce-like CRM system. (Captioned by AI)928×858 79.6 KB

5

Hello @dutta.marina ,
Could you please quickly check if the result of the Extract Data Table activity (the data table variable) contains data or not? If it contains data, then the issue is with writing the data into the Excel file, not with the extraction process. However, if the data table variable is empty, then the Extract Data table activity is not working as expected.

Let me know what you find!

6

@Ankit_Kumar2

Closing the Topic as the html developer had put wrong column name .This could be the reason for empty column values. I have asked her to revert the changes to proper column name.

1 Like
7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.