I. Function
With the value function, you can directly retrieve the row and column data that meet the conditions in the data set, and you don't need to drag the data set field to the cell and add the filter condition to access the number.
Different parameter combinations of the value function correspond to different access rules. For details, see Chapter II of the document.
The value function parameter setting has many forms, which can be directly input in the function, or can refer to cells and template parameters.
For example:
value("ds1",1,2) takes the data in the first column and the second row in the ds1 data set.
value("ds1",A1,A2) takes the column corresponding to the value in cell A1 in the ds1 data set, and the data in the row corresponding to the value in cell A2 in the ds1 data set.
value('ds1',1,2,A2) takes the data in the first column of the ds1 data set, and the corresponding data in the second column is the value of cell A1.
value($p1,1,$p2) takes the data in the first column and the p2 row of the p1 data set, where p1 and p2 are template parameters, and p1 is assigned the name of the dataset.
II.Use Introduction
1. Value(tabledata,col,row)
This function returns the value of TableData where the column number is col and the row number is row.
Create a new template, create a new DB query ds1: SELECT * FROM CUSTOMER, and write the formula in cell A1: = value("ds1",3,2), centered, and the rest will default to the third in the customer table The data in the second row of the column Washington, the effect is as follows:
2. Value(tableData,col)
This function returns a column of values whose column number is col in TableData.
Write the formula in cell A1 of the above template: =value("ds1",3), centered, because what is returned is an array, so we set the extended attribute to extend from top to bottom, which will return the third in the customer table Column data, the effect is as follows:
3. Value(tableData,targetCol,orgCol,element)
This function returns the elements in the targetCol column of TableData, and the value of the orgCol column corresponding to these column elements is element.
Write the formula in cell A1 in the above template: =value("ds1",3,4,"America"), centered and expanded from top to bottom, will return the third column element in the customer table, and this column The value of the element in the fourth column corresponding to the element is America, and the effect is as follows:
4. Value(tableData,targetCol,orgCol,element,idx)
This function returns the idx value of the Value(tableData, targetCol, orgCol, element) array.
Write the formula in cell A1: =value("ds1",3,4,"America",1), center, expand from top to bottom, will return the above Value(tableData,targetCol, orgCol, element) data column The first value of, the effect is as follows:
Previous：Array Function
