Qlik Community

Ask a Question

Integration, Extension & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
rupesh632
Creator
Creator

remove numeric columns from table

Hi Expert,

How to remove numerical columns from table and have separate table for it in qlik sense

i.e.

Table 1 into table1 & table2

a  2  5  e                 a 2 5

b  4   6  f                  b 4 6

c   6   7  g                c 6 7

d   8   3  h                d 8 3

4 Replies
shraddha_g
Partner
Partner

What is the expected output?

rupesh632
Creator
Creator
Author

              a 2 5

              b 4 6

             c 6 7

              d 8 3

shraddha_g
Partner
Partner

Is this one column including 4 characters or 4 different columns?

a  2  5  e                

b  4   6  f                 

c   6   7  g               

d   8   3  h

rupesh632
Creator
Creator
Author

fact table and dimension table structure only pk and fk are common  rest separate dimension(characters) and numerical values in fact table

fact table dimesnion

a 2 5        a e

   b 4 6       bf

    c 6 7       cg

     d 8 3      df