Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X
Hi,
I'm trying to identify missing values from a each entry of an infotable, Field values of input infotable are dynamic.
I need to find the count of missing values from each row and also the field names.
Anyone please give me some idea to do this.
Solved! Go to Solution.
Hello @BhavyaPC
I have created small script to iterate over infotable and field definition, try this script
var infoTable = YOURINFOTABLE; var dataShapeFields = YOURINFOTABLE.dataShape.fields; for (var i = 0; i < YOURINFOTABLE.length; i++) { for (var fieldName in dataShapeFields) { if(YOURINFOTABLE.rows[i][fieldName] == null ) { // Add your field, row and count in Infotable or array } } }
Hello @BhavyaPC
I have created small script to iterate over infotable and field definition, try this script
var infoTable = YOURINFOTABLE; var dataShapeFields = YOURINFOTABLE.dataShape.fields; for (var i = 0; i < YOURINFOTABLE.length; i++) { for (var fieldName in dataShapeFields) { if(YOURINFOTABLE.rows[i][fieldName] == null ) { // Add your field, row and count in Infotable or array } } }