Posted Thu, 05 Sep 2019 22:59:55 GMT by

Hi i am trying to display a result of a dataset can you please help . 

<AMDATABASE ACTIVITY="sql_query" SESSION="var_dbConnection" RESULTDATASET="Dataset">
/****** Script for SelectTopNRows command from SSMS ******/
SELECT [ ID card ] AS id
FROM [RPA_D007_InstantLoan].[dbo].[T002_Customer_Report]
<AMEXCEL SESSION="ExcelSession1" WORKBOOK="%var_customer_report%" AM_ENABLED="NO" />
<AMLOOP ACTIVITY="dataset" DATASET="Dataset" />


Posted Fri, 06 Sep 2019 05:15:28 GMT by

Hi Edson,

Could you be a little more specific as to the exact data you are trying to display. Are you trying to display the value for the first for of the id column of the dataset? Or are you attempting to see the entire column?  Also, are you receiving any error messages?

Posted Wed, 11 Sep 2019 15:39:47 GMT by

Hi Justin I want to see the entire column.

Posted Thu, 12 Sep 2019 05:46:37 GMT by

Right-click on the dataset in the variables pane after running (or during running) the process. Select Inspect to view the complete dataset.

You must be signed in to post in this forum.