Load certain data

[sculptorlv]

Hello .. very simple quastion, which I can't solve by reading manual

I need to load manual certain data. Not from Excel, but just data.

I have 3 variable: A, B, C and I have to load 5 rows with data for each variable (=column) like:

A B C

1 5 7

4 6 8

5 7 9

4 6 7

4 6 7

Please help me with a syntaxis. Thank you in advance!!

[tresesco]

Try like:

Load * Inline

"

Number, Description,

1, Apple[super]

" ;

Double quotes would be then considered as the INLINE start-end. Therefore, [] would be considered as part of your data.

[engishfaque]

Hi Ruslans,

Here it is,

temp:

Load A, B, If(not IsNum(C), '[', C) as C Inline

[

A, B, C

1, 5, 7

4, 6, 8

5, 7, 9

4, 6, Apple

4, 6, 7

];

Kind regards,

Ishfaque Ahmed

[sculptorlv]

Thank You!!

This is it!

[its_anandrjs]

You can try this way.

Ex:-

LOAD Number, Replace( Replace(Description,'(','['),')',']') as Description;

Load * Inline

[

Number, Description

1,        Apple(super)

2,        Orange(super)

3,        Lemon(Super)

];

Note:- Load your data with this symbol ( ) and the replace it by [ ].

Regards

Anand