Hi John,

This works, thanks for your help.

Regards

D

HI John,

I only added the missing columns to each tab, to test the ForEachLoop container. But then I encountered some problems. So I dropped that idea.

Currently, the solution that I...

Hi John

I've been trying to use the derived column transformation, unable to find a guide on how-to, that matches my requirement. I would really appreciate any helpful links.

I understand...

Hi Phil,

I tried using the ForEachLoop container. Here's what I did:

1) Made all my Excel Source tabs identical, by adding missing column headers (although they might not contain any data)....