Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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 - Master III
Partner - Master III

What is the expected output?

Anonymous
Not applicable
Author

              a 2 5

              b 4 6

             c 6 7

              d 8 3

shraddha_g
Partner - Master III
Partner - Master III

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

Anonymous
Not applicable
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