Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an excel sheet with 2 tables in the same sheet. But when I export that sheet to Qlik Sense, Qlik Sense recognizes it as one long table. is there a way to separate the two tables on Qlik Sense.
here is how is looks on Excel vs Qlik Sense
on Excel:
customer | product | quantity |
John | se22 | 6 |
John | se23 | 9 |
John | se22 | 3 |
John | se22 | 7 |
John | se22 | 6 |
John | se22 | 6 |
John | se22 | 87 |
customer | product | quantity |
Brian | se66 | 5 |
Brian | se23 | 3 |
Brian | se22 | 77 |
Brian | se57 | 44 |
Brian | se43 | 5 |
Brian | sr99 | 89 |
Brian | se11 | 2 |
on Qlik Sense: Its just one long table instead of two small ones
customer | product | quantity |
John | se22 | 6 |
John | se23 | 9 |
John | se22 | 3 |
John | se22 | 7 |
John | se22 | 6 |
John | se22 | 6 |
John | se22 | 87 |
customer | product | quantity |
Brian | se66 | 5 |
Brian | se23 | 3 |
Brian | se22 | 77 |
Brian | se57 | 44 |
Brian | se43 | 5 |
Brian | sr99 | 89 |
Brian | se11 | 2 |
If you are having this issue after loading the tables in Qlik Sense from Excel, you need to place a NoConcatenate statement before the loading of you second table. Qlik Sense will, by default, concatenate tables with the same columns names. You may also want to rename the fields of the second table or Qualify field names to avoid the creation of synthetic keys.
One other option would be to load both tables into one table and adding a column called Source to distinguish which table a row came from.
where customer <> 'customer' and len(trim(customer))>0
(or something similar)
Hello,
It's easy to fix that! You just need to give a name at each table on your excel sheet (like in attached file). Qlik Sense will recognize them like two differents tables.
https://trumpexcel.com/named-ranges-in-excel/
Regards