I have been trying to solve this for awhile and I really need help with DF. I have file with 5 columns, I need to validate this file against a whitelist file using an expression. I cannot do a left or right join because it will create additional rows that are not in the original file. Inner join will remove rows that I need. I also tried a seekbegin() to the whitelist file but I don't think I'm doing it right. Any help will be appreciated! Pre-expression: string VALIDITY file f string curr_line string COLUMNA string COLUMNB integer COLUMNC f.open("\\whitelist.csv","r") Here is the expression: begin f.seekbegin(0) curr_line= f.readline() while (curr_line) parse(COLUMNA,",",COLUMNB,",",COLUMNC) begin curr_line= f.readline() while isnull(VALIDITY) begin <conditional logic> then VALIDITY = 'VALID' else VALIDITY = 'INVALID' end end end
... View more