I am using Alteryx to read the Excel name with multiple sheets. How can I create column headers from the first and second rows? Thanks in advance!
Hey @NgaNgo, here's how I'd go about this - Alteryx isn't great at handling stacked headers and so this approach just isolates the first 2 rows, concatenates them together and then replaces the original headers with this newly-combined field:
Thanks so much .@DataNath