Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
ragavendrans
Contributor
Contributor

Reading list datatype from Cassandra

Hi,
I need to read LIST datatype data from Cassandra table. Can you please help finding a help material for this please? I tried searching but couldn't find much. Please help.

Thanks
Ragavendran S
Labels (2)
6 Replies
ragavendrans
Contributor
Contributor
Author

Hi,
Can you please help on this scenario?
In one of the column (List datatype) in Cassandra table, I have data like this.
[{Field1:10,Field2:'value1'},{Field1:20,Field2:'value2'}]

I have to process this data which is coming in a single record.
Please help.

Thanks
Ragavendran S
Anonymous
Not applicable

Hi,

 

Did u get any solution for this ? If yes, could you please help me as am facing the same issue .

Regards,

Haritha

manodwhb
Champion II
Champion II

can you try to extract list data type with tExtractJson?

Anonymous
Not applicable

Hi Mano,

Data is actually in arraylist with hashmap in it.

below is the format

[{Field1:10,Field2:'value1'},{Field1:20,Field2:'value2'}]

manodwhb
Champion II
Champion II

Hi Haritha,

 

you can do in tmap using index and substring function,can you try.

manodwhb
Champion II
Champion II

@rchinta,did it help you?