JSON EDL Advanced

Excel data location may define an array of excel cells. For this purpose, Boolean JSON attribute IS_ARRAY is set to true (if missing, default value is false). Accordingly, fields: ROW_INDICES and COLUMN_INDICES are used to define arrays of row and column indices. Since all row/column indices are given explicitly it is not needed to be consequent numbers hence more complex sets of excel cells are gathered in the array in this way. Column indices can be set in two ways: as integers (i.e. indices as number) or as column labels (as used in the Excel standard cell addressing). For example: "COLUMN_INDICES" : [2,3,4] or "COLUMN_INDICES" : ["B","C","D"] are both valid specifications. Also for continues and large sets of indies, an alternative string based syntax is also allowed e.g. "COLUMN_INDICES" : "2-40".

EDL attribute SOURCE_COMBINATION may be set true to define a piece of information obtained as a combination of data from different columns and rows. All data sources are concatenated into a single text value. If needed attribute COMBINATION_SEPARATOR may be used to set a separator string for the source combination concatenation.