Discussion Board for collaboration on QlikView Scripting.
I have 2 tables with same no. of fields and field names.
Table 1 contains the data of 2014 year.
Table 2 contains the data of 2013 year.
Can i use the below code to combine both into single table????
Load Field1, Field2, Field3 from
Store Table3 into 2013&2014 Data.qvd
Store Table3 into '2013&2014 Data.qvd'(QVD);
Also you don't need Concatenate word..
yes you can do that
but you will loose the year Information, so add the year as well
load Field1, Field2, Field3, '2014' as Year from
Field1, Field2, Field3, '2013' as Year from
If you have the same fields in both tables, then you can remove the concatenate Those two tables will automatically join one another if they have exactly the same fields
That doesnot create any duplicates right???
No I guess, don't worry
Yes you can...
How To /Missing Manual(18 articles)
I was wondering if there is 12/31/2013 in both the tables, will it cause any dupliocates???
I was wondering if there is 12/31/2013 in both the tables, will it cause any duplicates???
I know that you donot Need the keyword "concatenate" as it's done automatically by qlikview
I prefer to write it down anyway. If you look at your script it is clear what happens
especially if the previous table is not immediate before the table to concatenate
this depends on you