Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
you could add a field on loading each file.
for example
'2016-01' as YearMonth
then do a concatenate load
Dan
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.
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?
Then how do you identify that data set is jan,feb or march. Is there anything on the file name that says which monthperiod.
I can not guess what problems there might be with all the months in the same table
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.