I have a transformation in Pentaho (PDI) where I have several rows that the information is Null, but in each of the records there is a top row that has the data, I am using analytic query but for each empty row I have to create a column , I want all records to be considered regardless of how many rows are null.