Assign a specify column in a workflow/specify the name of heading of assigned column

[Jwwwson]

Hi, 

Since the name of heading of some columns of data keep changing with multiple batches of data, so that I need to amend the workflow every time when necessary. As shown below the name of heading of column c and d change, is there a way that I can assign a name or specify the column so that the workflow no need to change? 

ID	Name	1 Jun 2020 - 15 Jun 2020	16 Jun 2020 - 30 Jun 2020
USA-12345	John	12	26
HKG-23456	Peter	34	24
HK12345	Mary	25	2
USA34567	Henry	46	6

ID	Name	1 Jul 2020 - 15 Jul 2020	16 Jun 2020 - 31 Jul 2020
USA-12345	John	16	20
HKG-23456	Peter	38	42
HK12345	Mary	29	33
USA34567	Henry	50	54

Cheers, 

Jason

[ponraj]

Alteryx offers several ways to update column headers dynamically.  would be able to help you with sample workflow if you could share sample data. What you have shared is output you are looking for 

[DavidP · Accepted solution]

You can create a static list of Names (ID, Name, Date1, Date2) and use a Dynamic Rename to rename your fields