on 07-09-2018 5:32 PM
I have an Excel workbook which is having description in the first row. and second row onwards as usual like fields and then data. Now i want to extract data from second row which will start from the columns.means BODS needs to skip the first row of Excel which is having description.
No manual process like delete first row and create file format. It should be automated
Hi.
This should be quite straightforward.
Create Excel Template --> Import it in Dataflow --> Double click Excel --> Go To Source --> Skip First (either give 2 manually or configure a SP)
This would skip first 2 rows or the number of rows configures in SP
Regards. S
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
10 | |
9 | |
9 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.