topic Re: How could I split a data into 3 tables in App Development

How could I split a data into 3 tables

lichang422 — Thu, 25 Jan 2018 03:06:43 GMT

I using Qlik Sense

I import a excel file and I want to split data into 3 tables by "Type"

How could I do it ??

Thank you!!

Re: How could I split a data into 3 tables

prma7799 — Thu, 25 Jan 2018 04:30:24 GMT

Please share your expected output ...

Re: How could I split a data into 3 tables

karthikoffi27se — Thu, 25 Jan 2018 04:35:34 GMT

why do you want the source file to be separated?

Re: How could I split a data into 3 tables

lichang422 — Thu, 25 Jan 2018 05:09:13 GMT

In the below link is my original problem

Could I make 3 table without relation

I want to make 3 tables to show their data indepently.

And between 3 tables they don't have any relation . (It is meaning I can filter data at each table)

Original database is from ODBC , but you can't test reload,So i make an easily database by EXCEL

If you can answer me by ODBC. It is batter.

Thank you for helping.

Re: How could I split a data into 3 tables

rahulpawarb — Thu, 25 Jan 2018 08:12:11 GMT

Please refer below solution:

[Tmp工作表1]:
LOAD 
  [Equip],
  [Type],
  [Value],
  Capitalize([Value]&[Type]) AS [TypeValue]
 FROM [lib://桌面/test.xlsx]
(ooxml, embedded labels, table is 工作表1);


QUALIFY *;
[工作表1]:
LOAD 
  [Equip],
  [Type],
  [Value],
  [TypeValue]
 Resident Tmp工作表1
 Where [Value] = 'A';


[工作表2]:
LOAD 
  [Equip],
  [Type],
  [Value],
  [TypeValue]
 Resident Tmp工作表1
 Where [Value] = 'B';

[工作表3]:
LOAD 
  [Equip],
  [Type],
  [Value],
  [TypeValue]
 Resident Tmp工作表1
 Where [Value] = 'C';

 DROP TABLE Tmp工作表1;

UNQUALIFY *;

Regards!

Rahul Pawar