Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
smusayev
Contributor II
Contributor II

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
Creator III
Creator III

you could add a field on loading each file.

for example

'2016-01' as YearMonth

then do a concatenate load

Dan

maxgro
MVP
MVP

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
Contributor II
Contributor II
Author

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
Partner
Partner

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

maxgro
MVP
MVP

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

danansell42
Creator III
Creator III

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.