Displaying The data of a dataset coming from a select query.

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]
</AMDATABASE>
<AMEXCEL SESSION="ExcelSession1" WORKBOOK="%var_customer_report%" AM_ENABLED="NO" />
<AMEXCEL ACTIVITY="get_cell" SESSION="ExcelSession1" ACTION="rangebyreference" RESULTDATASET="Dataset" STARTCELLREF="A2" LASTCELL="YES" AM_ENABLED="NO" />
<AMLOOP ACTIVITY="dataset" DATASET="Dataset" />
<AMSHOWDIALOG>%Dataset.id%</AMSHOWDIALOG>

<AMLOOP ACTIVITY="end" />

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?

Hi Justin I want to see the entire column.

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