Hi,
I need to import two Flat Files, but I need to skip the 2nd and 3rd row from one of them (Headers in 1st row) and the other I need to skip the last two rows.
- sample of Flat File 2nd and 3rd row:
Row 1 - Header
Row 2 -12/01/2017 00:00 12/31/2017 0:00
Row 3 - No of Complete Downloads No of Partial Downloads Asset Name Series Info Genre Desc Sub Genre Desc Provider Brand Provider Id
- sample of Flat File last two rows:
Row *** - Period From Period To
Row *** - 01/10/2017 00:00 31/10/2017 00:00
Any help is very much appreciated
Thanks in advance,
Please do a dump import to a staging table in your PreProd table and Use ROW Number() to ignore the rows as you want.
Please note this approach will not help very well with large dump.