T
Tommy
I have two linked tables that contain daily data from two CSV files.
These tables are called 'PHD' and 'XANS'. Each table has the same
column headings, so the data is common between the two. I would like
two merge the data from these tables into a single table where the
data with the same headings appear together in the same field e.g. I
have a field called 'Tagname' in both linked tables. In the new table,
I would like all tags in the 'Tagname' fields of both PHD and XANS to
appear in a single field.
Ideally I would also like this table to automatically update as I
update the CSV files daily.
How do I go about doing this?
Regards,
Tom
These tables are called 'PHD' and 'XANS'. Each table has the same
column headings, so the data is common between the two. I would like
two merge the data from these tables into a single table where the
data with the same headings appear together in the same field e.g. I
have a field called 'Tagname' in both linked tables. In the new table,
I would like all tags in the 'Tagname' fields of both PHD and XANS to
appear in a single field.
Ideally I would also like this table to automatically update as I
update the CSV files daily.
How do I go about doing this?
Regards,
Tom