Cassandra output is overwriting data

[siddharthadutta]

Hi

I am a newbie to Pentaho

I have 2 excel files that I want to save in my Cassandra data base

Excel File 1:
Key T1 T2 T3

1	1a	2b	3c
2	1d	2e	3f
3	1g	2h	2i

Excel File 2:
Key T1 T2 T3

4	11a	22b	33c
5	11d	22e	33f
6	11g	21h	21i

Did a simple transformation from Excel input -> Cassandra Output

But if I run the same transformation using different files as input then whole data is getting overridden that was previously in Cassandra .

Have attached Screen shots for Cassandra output Options

[siddharthadutta]

Key T1 T2 T3 are Header rows of data

[marabu]

No wonder you loose previous data, if you enable option "Truncate column family".

[siddharthadutta]

Thanks Marabu

It helped us solve the problem