Hello Guys,
it is me again
I have Excel flat file with present company names and company numbers (which are actual serviced).
This file is linked into my front-end as dictionary.
I will do creating table query which will be transforming this file into Access database table with primary Key - ID and use it later in relations between tables. It is better in my opinion then create relations between external tables from Excel (don't you think?).
Problem is that this Excel table is living. Every day it is automatically reload and refreshing new data (from QlikView). This can be connected with deleting rows, uptading them, adding etc.
My question is: how to do it properly to get Unique IDs from this always changing table?
I thought about doing uptade query but i do not know how.
I also thought that I can add unique key in Qlikview and add it to the Excel file.
But in my head i have immediately this example:
UniqueID, Company
1, Com1
2, Com2
3, Com3
In system Com2 will be not more serviced so it will be deleted from list above.
What about 2 as Unique ID?
UniqueID, Company
1, Com1
3, Com3
Best Wishes,
Jacek
it is me again
I have Excel flat file with present company names and company numbers (which are actual serviced).
This file is linked into my front-end as dictionary.
I will do creating table query which will be transforming this file into Access database table with primary Key - ID and use it later in relations between tables. It is better in my opinion then create relations between external tables from Excel (don't you think?).
Problem is that this Excel table is living. Every day it is automatically reload and refreshing new data (from QlikView). This can be connected with deleting rows, uptading them, adding etc.
My question is: how to do it properly to get Unique IDs from this always changing table?
I thought about doing uptade query but i do not know how.
I also thought that I can add unique key in Qlikview and add it to the Excel file.
But in my head i have immediately this example:
UniqueID, Company
1, Com1
2, Com2
3, Com3
In system Com2 will be not more serviced so it will be deleted from list above.
What about 2 as Unique ID?
UniqueID, Company
1, Com1
3, Com3
Best Wishes,
Jacek