Qlik Community

Qlik Sense Integration, Extensions, & APIs

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

rupesh632
Contributor

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
Honored Contributor III

Re: remove numeric columns from table

What is the expected output?

rupesh632
Contributor

Re: remove numeric columns from table

              a 2 5

              b 4 6

             c 6 7

              d 8 3

shraddha_g
Honored Contributor III

Re: remove numeric columns from table

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
Contributor

Re: remove numeric columns from table

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