this is the sample data of text file first coloumn represents location field and second column asset tag how to load this data in data source if parsing then how do i parse with script
Thank you
1 ACCEPTED SOLUTION
One approach is to use the 'Custom (Parse by Script)' format for a data source.
Based on the file you provided, the following parsing script can be used in the data source:
Parsing Script
// The input value can be accessed through the variables named "line", "lineNumber" and "result"
// The function uses result variable to return parse result back.
(function(line, lineNumber, result) {
var map = {};
var items = line.split("|");
map['location'] = items[0];
map['asset'] = items[1];
result.addRow(map);
})(line, lineNumber, result);Data Source Record
.png){kind=link}
