topic how to create Key with Inline Data? in QlikView

how to create Key with Inline Data?

jim_chan — Fri, 26 Aug 2016 09:32:21 GMT

Hi guys,

i wonder how to create key for Inline Data????

Customer_Details:

LOAD * INLINE [

CustomerID, State, Customer

C001, State A, Company A

C002, State B, Company B

C003, State C, Company C

C004, State D, Company D

the CustomerID, Customer fields are available in another table. so i wanted to create something like:

CustomerID & '|' & Customer as key? where should i add in this line?

Rgds

Jim

sunny_talwar — Fri, 26 Aug 2016 09:34:24 GMT

May be in the preceding load:

Customer_Details:

LOAD *,

CustomerID & '|' & Customer as Key

INLINE [

CustomerID, State, Customer

C001, State A, Company A

C002, State B, Company B

C003, State C, Company C

C004, State D, Company D

];

jim_chan — Fri, 26 Aug 2016 09:36:15 GMT

Hello Sunny ,

I seee......

Thank you !

Rgds,

Jim