Discussion Board for collaboration on QlikView Scripting.
Is it possible to concatenate tables, which were loaded with keep prefix? My script is
For i = 1 to 4
Problem is that QlikView creates 4 different tables Tab-1 Tab-2 Tab-3 Tab-4 and i need only 1. What is the better way to solve it?
Why you are using Left(Keep) here?
Qlikview automatically concatenates(appends) if the tables has same number of fields with same fieldnames.
Can you explain how the table structure looks like once it gets loaded?
id as idnew
load * ,
Sorry misprint in code.
Left keep (cities)
@1 as city,
@2 as population
Use keep here to load only that cities that were previously loaded in tab "cities". At the end I want to get one table with 2 columns - city and population.
should auto concatenate them, and limit it to the ones already existing.
Thank you, it works. I wanted to use keep because its more flexible.
May be like this
Asummin that you have table with the name cities like below
Drop table cities;
Now Tab table has the data you need.