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!!

[its_anandrjs · Accepted solution]

Hi,

You can create the simple inline table load in your Qlikview file it self

Ex:-

Load * Inline

[

A, B, C

1, 5, 7

4, 6, 8

5, 7, 9

4, 6, 7

4, 6, 7

];

By this you get 3 fields A,B and C and you can edit this table any time.

Regards,

Anand

[engishfaque]

Hi Ruslans,

Use "First 5" before to Load statement such as given below,

First 5 //First 5 records will be loaded

Load * Inline

[

A, B, C

1, 5, 7

4, 6, 8

5, 7, 9

4, 6, 7

4, 6, 7

5, 5, 6

];

Kind regards,

Ishfaque Ahmed

[sculptorlv]

If I want to use not numeric value, should I put brackets '' to it?

'values not numeris'  ?

How I can put symbol [ to my not numeric values?

[its_anandrjs]

Then try this

LOAD  Text(A) as A, Text(B) as B, Text(C) as C ;

LOAD * INLINE [

    A, B, C

    1, 5, 7

    4, 6, 8

    5, 7, 9

    4, 6, 7

    4, 6, 7

    5, 5, 6

];

Use Text function to convert value into the Text format for fields.

Regards,

Anand

[sculptorlv]

Last quastion

How I can put symbol [ to my not numeric values?

[its_anandrjs]

Can you please share any sample for the same.

Regards

Anand

[sculptorlv]

I have the situation:

Load * Inline

[

Number, Description,

1, Apple[super]

]

How can I put [ bracket in my values?

[its_anandrjs]

In the table is there only single line with this symbol [ ] or may be there are many symbols.

Explain full table and requirement please.

Regards

Anand

[sculptorlv]

My main data are first two rows ..

I also want to make some correction by adding LOAD INLINE

but I can't use '[]' symbols in LOAD staitment

My current load is:

Load * Inline

[

Invntory_Journal_Nr, Journal_Order_Nr, Position_Nr, Location, Position_Description, Position_Measure_unit, Position_Cost, Position_Sell_Price, Quantity_System, Quantity_Calculated, Quantity_Difference

INV-001.01, V-201, 39385, 03T, Paletes INV, GAB, 1.675, 0, 0, 0, 20000

];