Inline table

[prasadreddy]

Hi Community, can any one explain what is 'Inline'? Inline Load

[#2]

The load statement loads field from a typed ASCII file, from data defined in the script.

inline is used if data should be typed within the script, and not loaded from a file. Use the Inline Data Wizard for help with the creation of load inline statements.

It is a scripting base table,which is manually created.

Regards-Biak

[engishfaque]

Dear Prasad,

To the point,

Load Inline:

Load inline can be used for adding data in existing tables or for reading new tables into the document.

In some cases, you may want to add data by entering it directly in QlikView rather than loading it from a file or a database.

Example:

Load * Inline [

Customer_ID, Customer, Address, City, Zip, Country

1101, Catering Service, Fisherman Drive

1102, Portsmouth, BH 354 RW, Great Britain

];

The first line (Customer_ID,Customer, Address, City, Zip, Country) lists the field names

The second line and third line (1101, Alexander's Catering Service, Fisherman's Drive 4, 1102, Portsmouth, BH 354 RW, Great Britain) contains the records that is to be added.

The star symbol * is equival ent to "all  fiel ds", which means that the statement should load all of the fields of the new record.

Kind regards,

Ishfaque Ahmed

[its_anandrjs]

Hi,

There are many uses of inline table

1. If you want to load mapping table with two fields you can use inline load.

2. If required introduce some small data in the application.

3. Where necessary introduce some more rows to the existing table you are able to add the data, Suppose you have 50 rows data and you want to test the model with some other rows then that are not in raw data then you just add that rows to the table.

Ex:-

Load * Inline [

Country, Sales

Germany,15852

France,125693

];

4.If required load the table which is based on the variables.

Hope this helps

[#5]

Hello,

I also have a question. How do you load inline numbers with decimal point ? In France, the decimal point is also a comma...

Thanks !

[linusblomberg]

Enter it as a point. Output format is specified in the autogenerated variables on the first tab of your loadscript. Your can also change under properties>number for a certain object.

[#7]

It works, thanks !!

[erivera10]

It is similar to a csv file, it is separated by commas.

name:

Load * Inline [

Id, field1, field2

1 name1, lastname1

2 name1, lastname1

];

Or can try

Inline Data Wizard

The Inline Data Wizard dialog is opened from the Insert, Judgment Load, Load Inline menu. It serves to create load inline statements in the script.

The dialog contains something very similar to a spreadsheet and in fact works like one in most respects. Note however that the calculated formulas are not evaluated in this spreadsheet as they would eg in Microsoft Excel.

Each column represents a field that can be loaded into QlikView by an inline table. Each row is a record of the table. A data cell by clicking on it is selected. You can then enter a value, by typing or pasting from the clipboard. Press Enter or an arrow key to accept the value and move to another cell.

The top row (label) is reserved for field labels. Double-click a cell to edit label. If no value is entered the field names used F1, F2, etc.

Edit Menu

The Edit menu contains some basic editing commands.

Insert Column Inserts a new blank column if one or more columns.

Delete Column Deletes (s) column (s) selected (s).

Insert Row Inserts a new blank row if one or more rows SELECTED.

Delete Row Deletes the selected row.

Tools menu

The Tools menu contains the Data Document command that opens the Document Data Wizard from which you can paste field values ​​from any field in the document. In this dialog you can see how many field values ​​are in a selected field. Might also choose to insert all values, the values ​​selected or excluded values ​​in the inline wizard.

Click OK to close the dialog and generate a load inline statement reflecting the contents of the grid of the table of dialogue.

http://help.qlik.com/es-ES/qlikview/12.0/Subsystems/Client/Content/Inline_Data_Wizard.htm?q=Inline

Best regards,

Erivera10‌