Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to concatenate 8 tables with mostly different field and few common fields between some tables . I created a link between all tables by creating an alias field of a date column in each table called "DateLink"
code is as follows:
TableA:
Load Field1,
datefield as DateLink,
Field2
...
From TableA.qvd
Concatenate (TableA)
Load Field3,
datefield as DateLink,
Field4
...
From TableB.qvd
Concatenate(TableA)
Load Field5,
datefield as DateLink,
Field6
...
From TableC.qvd
Concatenate(TableA)
Load Field7,
datefield as DateLink,
Field8
...
From TableD.qvd
Output:All the field names are concatenated. However, data from TableA and TableB are only populated in the concatenated master table . Data from tables C, D etc are not displayed even though their field names are displayed in the concatenated table.
Can you please help me identity the mistake i am making and correct the same?
How do you conclude that the data is not there? Have you created list boxes for fields Field7 and Field5, and these don't show anything, while loading only the TableC.qvd resp. TableD.qvd will populate the list boxes?
Are you filtering your records in the LOAD statements or in a subsequent resident LOAD?
Could you post the document log (which you can enable in Settings - Document properties)?