topic Get the data of field which is an object (contains another fields) in App Development

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

SurajD — Sat, 16 Nov 2024 18:26:33 GMT

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

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

Saravanan_Desingh — Thu, 25 Jun 2020 20:19:10 GMT

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,} ' ];

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

Saravanan_Desingh — Thu, 25 Jun 2020 20:19:56 GMT

Output.

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

SurajD — Fri, 26 Jun 2020 05:59:32 GMT

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