Hi Alteryx community,
Could anybody please help me with this problem? I need to combine data from 2 columns into a single column. The name of the headers for these 2 columns are the same.
So the reason why I am having this problem is because I am extracting this data from a system. The system makes use of template versions to record the data. So Sample 1 to 6 could be using version 1 where there are F and L pH sample tests but the template was revised to version 2 from Sample 7 onwards and in this case, the system will generate a new column but with the same header name for the same test. The templates could be revised in the future as well. Is there any solution that could combine all the data with the same header, regardless of how many columns there are with the same name, into a single column?
One more thing is that my current Alteryx workflow has a dynamic rename tool following the input tool to take the first row of data as headers and since headers cannot have the same name, the tool will have a warning message stating that there were multiple fields named "pH (F)" and that it is renamed to pH (F)_2.
Appreciate any help that you could provide. Thank you!
__PRESENT
