Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
SurajD
Contributor II
Contributor II

Get the data of field which is an object (contains another fields)

Hi Guys,

I am using Qlik sense with ODBC connector after which I am able to load the data and generate the reports properly.
Issue : I am not sure how can I get the specific value to dimension or measure from the field which contains another fields.
for example : 
I have fields(DB columns) like name,surname and cars
So car can have another attributes(crateDB object) like carname,carID,cartype etc
I am getting below data for field "car" (if i drag field car in sheet)- >
{"carname":"Audi","cartype ":"SUV","carID":123456,} 
{"carname":"Volvo","cartype ":"SUV","carID":789432,}  and so on ....

could you please give me details how can i get only carID ? I tried by doing edit expression for the field car but did not find exact function/expression as i am new to the Qlik .

Really thanks in advance,

Regards,

Suraj Dighodkar

Labels (1)
3 Replies
Saravanan_Desingh

One solution is.

tab1:
LOAD *, TextBetween(F1,'"carID":',',') As CarID;
LOAD * INLINE [
    F1
    '{"carname":"Audi","cartype ":"SUV","carID":123456,} '
    '{"carname":"Volvo","cartype ":"SUV","carID":789432,} '
];
Saravanan_Desingh

Output.

commQV81.PNG

SurajD
Contributor II
Contributor II
Author

Hi @Saravanan_Desingh 

After using 

TextBetween(F1,'"carID":',',')

 I am able to get the data of fields inside field correctly.  The car data is just example but we are having some other huge data, and I am able to get those data also, Thanks for suggesting the solution it works for me. 

Thank you.

Regards,

Suraj Dighodkar