Error with downloading .xls file from web with data not starting on the first line

ibesmond

Does anyone know how to solve this? The .xls format doesn't give you the option: Start Data Import on Line "N".

I thought a sample tool might help, but it can't read a table to progress to the sample tool.

I am pulling the file our a URL so I don't want to change the file format manually.

OR - Error.png

OR - Error2.png

OR workflow.yxmd

Dynamic Processing

Download

Accepted answers

fmvizcaino

Hi @ibesmond ,

You are doing everything correctly!

You have just forgot to check one simple little thing that I also keep forgetting everytime I'm using a text input hahaha - the column size is adjusted to the number of characters of the maximum string found, so in your case it will have 28 characters only that will cause a truncation for the sheetname you are inserting in your formula.