I have users uploading excel file to run the workflow - now for certain files the data start from a specific row. Whats the best way to do this either handle it from my end or ask user to update the header row number?
Solved! Go to Solution.
Does your data contain same headers? If yes, then you can handle that in your workflow by simply filtering it.
If not, what I would do is find where the number of nulls become least, that should be where your actual data starts.
This is under the assumption that your data contains instructions or additional info above your actual data. Plug this macro and try. Read your data from 1st line and pass it to this macro.
Otherwise, you can also follow the suggestion from @apathetichell a couple comments back, whereby you put an extra Interface tool with the FileBrowse, asking the user which row the headers are on, and pass that to the Input tool as well.
Thank you. This worked perfectly. Much appreciated.
User | Count |
---|---|
60 | |
24 | |
24 | |
21 | |
21 |