Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Inline Load - text format column

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

1 Solution

Accepted Solutions
sunny_talwar

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

];

View solution in original post

2 Replies
sunny_talwar

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
Not applicable
Author

Easy - Thank you!!