Forum Discussion

AOD's avatar
AOD
Icon for Helper III rankHelper III
6 years ago
Solved

New table creation /transformation

Hi All,    I have a audit table which stores changes done at field level, would like to transform into new table to store the latest changes with old and new value as below. Need help on how can t...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    AOD , Try both as new columns

     last date = maxx(filter(Table, [Employee] =earlier([Employee]) && [Modified date] <earlier([Modified date])),[Modified date])
 last status = maxx(filter(Table, [Employee] =earlier([Employee]) && [Modified date] =earlier([last date])),[Field 1])

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

AOD , Try both as new columns

 last date = maxx(filter(Table, [Employee] =earlier([Employee]) && [Modified date] <earlier([Modified date])),[Modified date])
 last status = maxx(filter(Table, [Employee] =earlier([Employee]) && [Modified date] =earlier([last date])),[Field 1])

 

AOD's avatar
AOD
Icon for Helper III rankHelper III
6 years ago

Thanks Amit for solution.

 
 

I have below output now. Is there as way that I can just keep last work of every employee in the table

 

Thanks for your help.

AOD