Excel Merge

Hello ETL Team,

Is it possible to copy the content of 2 registers defined in an Excel file (start-end variable) to one register?

Thx
Thomas

Hello

I am really confused about your question, please clarify

Sorry Mike

I wrote this text in my dentist's waiting room

I'll specify it now:

I have an Excel file with 2 tabs.
Tab 1 "Business Line Actual Year"
Tab 2 "Business Line Next Year"

Columns A to M are the same in both tabs.
Tab 1 contains data from N to Z.
Tab 2 also contains the data from N to Z.

Now, I would like to copy the data from tab 2 "N to Z" 
from "AA" into tab 1.

I would also like to have screenshots attached.
But your limitation is very low

Thank you for the clarification

Please have a look at block transformations, they were created for cases like yours

www.etl-tools.com/wiki/advanced-etl-proc...on/mark-data-blocks/

Hello downing,

I created a loom video for you to understand how to combine data blocks , hope this is useful . CLICK HERE . Watch it at 1.5X

Question to admin
1. although I was successful in creating data blocks from two tabs , how to combine data blocks from two different files ? 

Hi Prashant

Re: although I was successful in creating data blocks from two tabs , how to combine data blocks from two different files ? 

Just add another "mark data blocks" tab and point it to the second file
www.etl-tools.com/wiki/advanced-etl-proc...on/mark-data-blocks/