Forum Discussion
Helper IIIHow can I Replace null values in Person-based column
I think you can expand that 'List' or 'Record' by clicking the two arrows and it will offer you the option to expand as new rows or to fill the cell with the values. In the case of your null values, you can use a Replace Values transformation and replace 'null' with something else. You're best bet is to go upstream to the source and force a value to be selected in the Person Field. That is, if you have that option available.
Sorry, I did not see that that column is of Record type, gemcityzach is correct. You have to click the double arrow in the upper right of the column, and expand to the columns that you are wanting to report one. Then, use replace with each column.
Helper IIIHey- no worries Anonymous - all sorted now and I know you would have been on it 🙂