Sharepoint input tool - trying to convert field names to row 1 values

[Jake5]

Hello,

While loading the attached .txt file into a Sharepoint input tool, I'm trying to convert the field header (i.e. REPORT NUMBER:  R00846       TRAILER FEE COMPENSATION             PAGE:      1)  into row 1 values and current row 1 values becomes row 2 and so forth.  Unselecting "First row contains field names" does not accomplish this as it errors out and no data is produced.  Is there a toolset subsequent to the SP input tool that can accomplish this?  

[jrlindem · Accepted solution]

Not sure why your Sharepoint input tool isn't working.  Here's a work-around if you want to get creative:

1. Use a Text Input tool to manually create placeholder field labels (ie F1, F2, F3, etc.  The amount of placeholder fields should match the other dataset
2. Union the Text Input and the Sharepoint Input; then set the union method to "Auto Config by Position."  Make sure the generic labels are in Stream #1
3. Then use a Select Tool to name the fields whatever you want

Couple notes:  If you still need the headers from your Sharepoint Data to appear as Row 1 then you can explicitly name them in your placeholder text input tool as the first row of data.  If you need to manage the order of the data, add a Record ID.

Example:

Hope that helps, -Jay

[dreldrel]

What is the version of the SharePoint Tool that you are using? As Alteryx has modified these toolsets a few times over the years.

[Jake5]

Thank you - this was very helpful!