How could I split a data into 3 tables

[lichang422]

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

[prma7799]

Please share your expected output ...

[karthikoffi27se]

why do you want the source file to be separated?

[lichang422]

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.

[rahulpawarb]

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