Adding columns before a specific columns

DanielCarro

Hi,

I need some guidance/advice to approach this task on alteryx.

I have a range of columns from A:CL but columns  A:X can have more columns to be added and require the rest of columns to move to the right.

For example:

COL X	COL Y	COL Z
Pension	ER Pension	Employee ID
10.36	25.36	123
15.69	28.96	456

But if there are any new column updates, these shall need to be taken into account and Col Z to move right.

Expected Result:

COL X	COL Y	COL Z	COL AA	COL AB
Pension	ER Pension	Car App	Car Mileage	Employee ID
10.36	25.36	5.69	5.9	123
15.69	28.96	8.699	5.2	456

Note: Columns from AB to the end always remain the same, just the middle data is 'dynamic'

Kind Regards,

Dan

DataNath

Hey @DanielCarro, I'm not sure I'm following the logic properly as the provided desired output doesn't seem to follow this i.e. Col Z doesn't move right as you state. However, I just thought I'd show an example of how you can set up your workflow to accommodate for new fields in a certain position.

The first time you run your workflow with the base order, i.e. fields that will always be there, bring on a select tool like so and move the [*Unknown] field to where you want new fields to be inserted on the next/future runs:

Now, if I do another run and add in two more fields, they'll appear where these previously unknown fields are according to the Select position i.e. before COL Z:

I know the order is different in your example i.e. Z before AA/AB but this shows the functionality in telling Alteryx where to place future/unseen fields.

Dynamically position new fields.yxmd