topic Re: Inline Load - text format column in QlikView

Inline Load - text format column

Anonymous — Tue, 29 May 2018 12:06:30 GMT

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

Re: Inline Load - text format column

sunny_talwar — Tue, 29 May 2018 12:09:34 GMT

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

];

Re: Inline Load - text format column

Anonymous — Tue, 29 May 2018 13:08:23 GMT

Easy - Thank you!!