I was trying to rebuild your example as you described it, but in vain. I trid with/without "noconcat", with(out) mapping and so on. My table2 will not be appended to table1 when I use the NoConcatenate like you described it.
I assume table1 and table2 have same fieldnames (fieldname [FIELD3] !), So can you send a little exam to see what is wrong ?
Partly they have the same fields. Table1 has one field that table2 doesn't. Table2 has two fields that table1 doesn't have. They share two fields. The names of the two shared fields are the same in both tables.
I am attaching an example (in two stages, because you can only upload one file per post/reply).
Table2.qvw performs a binary load on table1, then loads it's own table with the addition NoConcat. The result however is one table with lines from both tables.
table1.qvw 131.0 K
you do have two tables. Take a look at the table viewer (ctrl T or smart icon). There you can find TWO tables linked together by a so called sync-table (in this case "$Sync1"). The corresponding message can be seen in the load output window, it is like "$Syn 1 = COUNTRY+SALES" This is to say QV links automatically table1 and table2 together via same fieldnames. This is very a very good and convenient feature, if you familar with it. But if you do not know how to use this feature it can have surprising affects.
When you look at my attached app, the qualify() - statement works fine. Proof it using the table viewer again or during creating a new table box. See the pull down list "Show fields from Table".
So I think you need to know what is the key to link the two tables together. My first guess it is country and area. If so, rename xflag to area (this seems to fit to area) and load again. Or add ID to the first table, if this is your common key-field. Or use qualify to get two independent tables.
OK, I suppose this is a lot of home work, don't hesitate to ask for details if necessary.
Hi Olaf again,
when you look into the script you will find the qualify-statement before the load-table2-statement:
load * Inline [
ID, COUNTRY, AREA, SALES
1, NL, A, 10
2, FR, A, 30
3, FR, B, 25
With this version of the script table1and table2 won't be linked together, because the fieldnames of table2 are qualified eg. : table2.ID and table2.COUNTRY. As an result the tables are NOT linked together.
But if you comment the qualify()-statement and reload again, you will see the link (again).