Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

smusayev
New Contributor

Loading several table with same column names

I have several reports, that I receive every month (Jan, Feb, March, etc). 

All of the tables have the same exact column names but obviously different rows.

I am trying to load all 3 tables into Qliksense,  however I get a synthetic key error.

Before each load I give each table a table name

table1:

Load *

From \\\\\\\ qvd;

table2

Load *

From \\\\ qvd;

etc.  

I need to have all three table in the app to be able to compare the data beween each report.  I cannot join or concatenate the data because there is nothing in the tables that will be able to differentiate the range of date of each table.  The tables do not have any time stamp data.

Please advise and let me know if you have any questions.

Thank you in advance.

6 Replies
danansell42
Contributor III

Re: Loading several table with same column names

you could add a field on loading each file.

for example

'2016-01' as YearMonth

then do a concatenate load

Dan

MVP
MVP

Re: Loading several table with same column names

You can do that

Table:

Load

    'Jan' as Month,

    *

From \\\\\\\ qvd;

concatenate (Table)

Load

    'Feb' as Month,

    *

From \\\\ qvd;

All of the tables have the same exact column names but obviously different rows.

I am trying to load all 3 tables into Qliksense,  however I get a synthetic key error.

If you have the same number and names of columns, Qlik will auto concatenate.

smusayev
New Contributor

Re: Loading several table with same column names

I think that if I will concatenate everything into 1 table I will not be able to see all the different comparisons, that I would like to see.

Do you guys have any other suggestions?

shree909
Valued Contributor II

Re: Loading several table with same column names

Then how do you identify that data set is jan,feb or march. Is there anything on the file name that says which monthperiod.

MVP
MVP

Re: Loading several table with same column names

I can not guess what problems there might be with all the months in the same table

danansell42
Contributor III

Re: Loading several table with same column names

I also can't see any problems with concatenating all the tables if the fields are all the same.

As long as you add a new field to identify which month/file it is then you can do set analysis to perform any comparisons.