How to join 5 tables carrying almost same data??

[Anonymous]

Hi,

I have 5 tables coming from excel carrying the data  each year like 2009.... to .2014.

These tables carry same columns but data is different according to the year.Can any one suggest me how to avoid synthetic key and I am wondering whether to join or concatenate, If possible pls explain with example.

Your help is appreciated.

Regards,

Sharma.

[stevedark]

Hi Sharma,

Please see this post on include files:

http://www.quickintelligence.co.uk/qlikview-include-files/

It may point you in the right direction.

Steve

[Anonymous]

Hi steve,

I need to check some tables coming from the excel and i devevloped a code which checks the date validation and number field  validation but i am wondering how would i Incorporate at qvd level to check this validation .I need a multiple iff condition to check this.

Can you help me pls

Regards,

Sharma.

[Anonymous]

Hi steve,

This is my table

GS1:

LOAD rowno(),
     date([Work Order Interruption Start Date],'DD MMM YYYY') as OBJ_GSoS_StartDate,
     Time([Work Order Interruption Start Time],'HH MM SS') as OBJ_GSoS_StartTime,
     date([Work Order Interruption End Date],'DD MMM YYYY') as OBJ_GSoS_EndDate,

From
BI Industrialisation\Data Files\GSOP\GS1\GS1 - Supply Restoration - MI - 2014-15.xls]
(biff, embedded labels, header is 20 lines, table is [TOT FAILURES GS1 YTD$])
WHERE [IN/ OUT/ QUERY Following Investigation]='OUT';

This is my table when i am loading the data in qlikview , I need to write a code that will check the above date field or isnum field are in write format.

if all of the fields are in right format

Store GS1 into correct.qvd

or

if any other fields are in wrong format it should

store GS1 into incorrect.qvd and this should send a message or alert the user that this needs correction.

Your help is indeed appreciated,

Regards,

Sharma.

[#5]

Store each table data into different Qvd, later you can concatenate all the qvd’s.

after concatenating the qvd's again store them into original qvd, once you enter the new data ,that also will concatenate with the old data and it will store in the original data.