Inline Load - text format column

[Anonymous]

Hi,

I am attempting an inline load that has both number & letters in one column. The rows with both numbers/letters works correctly but the rows with only numbers are not being picked up:

LOAD * INLINE [

text (CPTY),  Trading CP

0MTSS,  Broker

0BBISC,  Broker

0035,  Broker

0095,  Client

...];

Is there a way of formatting the 'text (Cpty)' column to be text on an inline load? I've attempted wrapping the numbers with '', "",(),text() etc but to no avail.

Your assistance would be much appreciated

[sunny_talwar · Accepted solution]

May be this

LOAD Text([text (CPTY)]) as [text (CPTY)],

[Trading CP];

LOAD * INLINE [

    text (CPTY), Trading CP

    0MTSS, Broker

    0BBISC, Broker

    0035, Broker

    0095, Client

];

[Anonymous]

Easy - Thank you!!