Add a column from preceding file load

[martin_hamilton]

Hi

i wish to include a field from a preceding load into the next file load as a new column but keep the files separate.

e.g.

SALESPERSONID:

Salesperson_Name

Salesperson_Number

SUBSCRIPTION:

SubID,

SubName

Sub_Sales_ID,

Sub_Sales_ID_Name,

Lookup('Salesperson_Name','Salesperson_Number',[Sub_Sales_ID],'SALESPERSONID') as [Sub_Sales_ID_Name]

SUBSCRIPTIONINVOICES:

Sub_Invoice_ID,

SubID,

Sub_Sales_ID_Name

Have tried to use:

Peek(Sub_Sales_ID_Name) as [Subs_Invoices_Sales_ID_Name]

But this isnt working.

Thanks

Martin

[Gysbert_Wassenaar]

I'm afraid I don't understand what you're trying to do. It's unclear to me where what fields are coming from and where they should end up. Can you explain with an example?