Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
lichang422
Creator
Creator

How could I split a data into 3 tables

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

zoomit.png

4 Replies
prma7799
Master III
Master III

Please share your expected output ...

karthikoffi27se
Creator III
Creator III

why do you want the source file to be separated?

lichang422
Creator
Creator
Author

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
Specialist III
Specialist III

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