Forum Discussion

SteveMForm's avatar
SteveMForm
Icon for Helper III rankHelper III
2 years ago
Solved

How can I Replace null values in Person-based column

Hi Folks   any ideas on this- I dont get the option to replace values, but wnat to replace the nulls    
Need Help
  • gemcityzach's avatar
    gemcityzach
    2 years ago

    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.

gemcityzach's avatar
gemcityzach
Icon for Helper IV rankHelper IV
2 years ago

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.

  • SteveMForm's avatar
    SteveMForm
    Icon for Helper III rankHelper III
    2 years ago

    Hi gemcityzach - thanks- sorted. 

     

    I expanded the records be selecting the two arrows and selected the values I wanted to expand into new columns and now the option to replace values comes up. All sorted.

     

    I didnt have the option to do at source as it's a person based column so won;t let you add a value that isn't in my organisations GAL (Global Address List)

     

    Thanks Anonymous for your help