Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What is the expected output?
a 2 5
b 4 6
c 6 7
d 8 3
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
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