topic Re: two tables in one excel file. How to separate them after importing to Qlik Sense in App Development

two tables in one excel file. How to separate them after importing to Qlik Sense

Mch201 — Sat, 16 Nov 2024 00:44:36 GMT

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

Re: two tables in one excel file. How to separate them after importing to Qlik Sense

GaryGiles — Thu, 28 Jan 2021 11:06:26 GMT

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.

Re: two tables in one excel file. How to separate them after importing to Qlik Sense

mikaelsc — Thu, 28 Jan 2021 12:03:00 GMT

where customer <> 'customer' and len(trim(customer))>0

(or something similar)

Re: two tables in one excel file. How to separate them after importing to Qlik Sense

Seyko — Thu, 28 Jan 2021 13:25:03 GMT

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