Add a column from preceding file load

martin_hamilton — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Add a column from preceding file load

Gysbert_Wassenaar — Mon, 19 Sep 2016 16:13:09 GMT

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?

topic Re: Add a column from preceding file load in QlikView

Add a column from preceding file load

Re: Add a column from preceding file load