Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Adding lines into a Populated Table

I have two table that are linked by a field. This two tables are getting making login into a internal system.

But I have to complement one of the tables with 3 more lines manually.

In attachment I create a example using two table.

If I would like to add content into the field company like: J4, H7, S4 even that the other informations get empty, How can I make?

Thank you!

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Not sure what you're asking. If you want to append data to a table you can use the concatenate keyword:

Concatenate(Table1)

load * inline [

Company, Address, Value, Position

J4, Here, 1,

H7, There, , Bottom

S4, , 3,

];

The inline is just an example. You can load data from another excel file or any other source.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

Not sure what you're asking. If you want to append data to a table you can use the concatenate keyword:

Concatenate(Table1)

load * inline [

Company, Address, Value, Position

J4, Here, 1,

H7, There, , Bottom

S4, , 3,

];

The inline is just an example. You can load data from another excel file or any other source.


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

Hello Gysbert!

It is exactly what I need.

Thank You!