Excel To Excel Mapping

  • Posts: 76
  • Thank you received: 2

Excel To Excel Mapping was created by ankita

I design the mapping for Excel to Excel in Advance ETL Processor, But when I define the source (Reader), What is the Footer attribute works for ?
1 month 3 weeks ago #20135

Please Log in or Create an account to join the conversation.

  • Posts: 76
  • Thank you received: 2

Replied by ankita on topic Excel To Excel Mapping

Haeder = from where my table starts, Row number
Footer = ?
1 month 3 weeks ago #20136
Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 1078
  • Karma: 3
  • Thank you received: 127

Replied by Peter.Jonson on topic Excel To Excel Mapping

Say for example you want to load invoice lines.

Invoice has a header and a footer
The header is always five lines and footer is aways 7 lines

These options allow you to skip those limes
Peter Jonson
Support Analist
The following user(s) said Thank You: ankita
1 month 3 weeks ago #20138

Please Log in or Create an account to join the conversation.

  • Posts: 76
  • Thank you received: 2

Replied by ankita on topic Excel To Excel Mapping

Okay thanks,
If I have 2 tables in one Excel sheet, then I will import same file 2 times for reading both tables separately by specifying header and Footer
Is this possible?
Could you please see the attached file and suggest me the header and footer for both tables
1 month 3 weeks ago #20141
Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 1078
  • Karma: 3
  • Thank you received: 127

Replied by Peter.Jonson on topic Excel To Excel Mapping

For the first table, it would 4 and 6, for the second 11 and 0.

The problem with tables like this that no one can guarantee how many records table 1 or 2 will have.

Header and footer work very well when you have only one table per sheet (Invoice for example).

With multiple tables, it is better to set up named ranges in excel and extract the data from the named range
trumpexcel.com/named-ranges-in-excel/
Peter Jonson
Support Analist
The following user(s) said Thank You: ankita
1 month 3 weeks ago #20144

Please Log in or Create an account to join the conversation.

  • Posts: 76
  • Thank you received: 2

Replied by ankita on topic Excel To Excel Mapping

Hi Peter, Could you tell me how can I import 3 different excel files in single mappings
The way i define is, I create 3 separate readers and import each files, but i don't want to Join the files on specific condition, because all files have totally different column values.
Can't I just connect all readers to single validator?
1 month 3 weeks ago #20145

Please Log in or Create an account to join the conversation.

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies