Forum Discussion

orangebloss's avatar
orangebloss
New Member
3 years ago
Solved

Returning Column Name of first non- Null value

I have a CSV file I'm using as a source, I'm needing to return the column name of the first non-null value in a row.    In Excel I'd use a simple index match. I've worked out how to return the firs...
Need Help
Tips and Tricks
  • slorin's avatar
    slorin
    3 years ago

    Add a List.RemoveFirstN

    List.Skip(List.RemoveFirstN(List.Zip({Record.FieldValues(_), Record.FieldNames(_)}),4), each _{0}=null){0}{1}

    Stéphane 

slorin's avatar
slorin
Icon for Super User rankSuper User
3 years ago

Hi

Add a new column

List.Skip(List.Zip({Record.FieldValues(_), Record.FieldNames(_)}), each _{0}=null){0}{1}

 Stéphane

  • orangebloss's avatar
    orangebloss
    New Member
    3 years ago

    Thanks - that's almost there, however the columns I'm searching start at column 5 (first four columns are populated) how would I change this to accomodate this?

     

    It also seems to return the same result for every row?