After creating a intline load table with column and empty of data how do i insert data into that table from a select on some data imported in qlik from an excel

[#1]

After creating a intline load table with column and empty of data how do i insert data into that table from a select on some data imported in qlik from an excel?

Normaly in excel i do

create table....   

Insert into table from(select...

Also not sure how to ask but how doesn t the script work in qlik like initially i was trying to write normal like sql and didn t work after i see some examples and not sure about rule of order of comands and so on

[Gysbert_Wassenaar]

You can use the concatenate keyword to indicate that a load should be appended to an existing table:

MyTable:

LOAD * INLINE [

FieldA, FieldB, FieldC

];

CONCATENATE(MyTable)

SELECT * FROM MyDatabaseTable;

But you may not need the inline load. The SELECT load statement will create the table and load the data if a table with the exact same number of fields with the exact same field names doesn't already exist.

[#3]

TOT NECESAR Send.xlsx - Speedy Share - upload your files here

My use for Inline is to use for manual input of 2 values for start.

In excel is more clear if you can see the link.

I have to make also a cursor because in step i will generated segments of data that i have to create table for so i make other where on those result  with the initial table to generated other till end of loop.

If i follow your code it should look like this but its not  working giving error and trowing me out  so i have made a mystake but again hard to understand where as no clear explanation where to focus present .

Directory;

LOAD [Tip mişcare],

     Material,

     Lot,

     Comandă

FROM

[TOT NECESAR.xlsx]

(ooxml, embedded labels, table is Foaie1);

MyTable:

LOAD * INLINE [[Tip mişcare],

     Material,

     Lot,

     Comandă

     ];

Concatenate(MyTable)

Select * from

TOT NECESAR.xlsx]

(ooxml, embedded labels, table is Foaie1);

Where Lot=78184 and [Tip miscare]=101;