limitation of columns

[Pascal_R]

Hi Team,

I have a workflow which is adding columns on a daily basis to an Excel file. Is ther an Option to limitate the QTYs of columns like max 150.

How can I "tell" Alterix to delete the oldest entry when adding a new one?

Regards,

Pascal_R

[patrick_mcauliffe · Accepted solution]

Depending on how many rows you have, this might not be realistic, but I would start by trying:

add a record id, then transpose the whole table so that you have columns: record if, name , value.  

Add a tile tool with the option of unique value on record id and unsorted input.  The tile sequence id will be the order of columns from left to right.

So, if you want the oldest column dropped, add a filter for tile seq id != 1, then use the cross tab tool to flip your data back into a table.  

See attached.

[DavidP · Accepted solution]

Here's another way to remove the oldest column