niff | compares two Nix expressions and determines

So trying to keep this section very brief: I have two tables. Tbl1 has the financial accounts by year for each company in seperate rows. Table2 has each company only once and all the financial data is now in one row. How do i do that? Currently attempting it with Collections have a second attempt going with Arrays.

Hi guys so i have two tables Figs1 and Sabi. Figs1 is set up like: NIF,PeriodEnding, Materials, Depreciation, Non-Trading Income, Total Interest, Pretax Profit, TotalEmpRemu.

So you'll get repeating Company IDs with each each of their financials as the rows.

In Sabi it changes to each company has 1 row and all that data is in columns e.g. PeriodEnding_Latest, PeriodEnding -1, PeriodEnding -2 etc. till -6. I have made a collection for each column in Figs1 and i want to update the table Sabi in the correct order.

So PeriodEnding collection will have {(31/12/2018), (31/12/2017), (31/12/2016), (31/12/2015), (31/12/2014), (31/12/2013)}

Those values need to go to PeriodEnding_Latest, PeriodEnding -1, PeriodEnding -2 etc.

I have the update SQL Statement and filled it with variables: