If I make it blank and save, then it is defaulting to; maybe it is expecting a default value? ... View more

I think maybe I didn't explain it well. SKIP value is not in the rows, SKIP is in the column header. when we say  col1 <> 'SKIP' i believe it will skip all rows with value 'SKIP' but my intention is to remove columns whose header is called 'SKIP'   Here is an example of file header :   FirstName|Skip|Skip|City|State|ZipCode|Skip|LastVisitDate|Skip|ExtId   The file is not predefined, no of columns in a file will vary, header positions will vary, place where 'SKIP' can exist in the header will vary from file to file.     ... View more

@Shu_ashu    Skip is column header name, so how does the query look like to exclude columns whose header name is "SKIP"? ... View more

@Wynner  It is giving an error as shown below, i have also uploaded screenshots of configuration for reference. ... View more

@Shu_ashu  : Thank you so much for the link, it covers part of my need. The other thing is to assign the lookup value to attribute so I think the solution is  ExecuteSQL -> ConvertAvroToJson -> EvaluateJsonPath   can we do it in one step instead of 3 like above?  All I am pulling is one field from the database table.   Query: select id from table A     ... View more

@Wynner ;  I left it to default, which seems to be  ;     ... View more

Hi,   I think it is slightly different, it is remove header when a file is split in to smaller files where as for me it is one file with multiple columns with same header name and i need to ignore certain columns based on a column name. ... View more