how to create Key with Inline Data?

[jim_chan]

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 · Accepted solution]

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]

Hello Sunny ,

I seee......

Thank you !

Rgds,

Jim