search for a specific name and set the row as the header

Question

Hello Alteryx Community,

Do Alteryx have the capability to search for a specific name like "Vendor" and then set the entire row as the header or column names?  The reason is that multiple users have different starting row in their input file.  User A's column header is located on the 3rd row, while user B's column header are in fourth row.

Appreciate if you can share with me you workflow with your sample input.

Thanks in advance.

FinnCharlton · Accepted Answer

Hi @PassION_es , if I've understood correctly this workflow should help you. Some of the sample data starts on Row 3 and the other on Row 4 - the correct start point is dynamically chosen and the headers renamed. Hope it helps!

CoG · Accepted Answer

This is less likely, but I figured I would throw this out there. If you don't want/don't need to drop all the rows above the header columns.

Version 1 will work just fine. If the Vendor column is not always in the same column. Then something like this workflow would be what you need:

binu_acs · Accepted Answer

@PassION_es Another method, set the input tool configuration like the below and add a flag which sets to 1 from the vendor field and filter only those values where flag=1, attaching a sample workflow