Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Juancadlc95
New Contributor

Convert JSON to QVD

Hola estoy intentando convertir un script de JSON a un QVD pero no se como realmente, si alguien me pudiera apoyar se los agradecería mucho. Quiero separar cada select para hacer un QVD de cada uno.

RestConnectorMasterTable:
SQL SELECT
"__KEY_root",
(SELECT
"sort",
"order",
"max",
"offset",
"totalCount",
"count",
"__FK_meta"
FROM "meta" FK "__FK_meta"),
(SELECT
"q",
"courseType",
"status",
"interestLevel",
"referrer",
"paymentStatus",
"enrollmentStatus",
"seller",
"client",
"saleGroup",
"isEnabled",
"studentName",
"saleOrderStartDate",
"courseName",
"customStatus",
"channel",
"manager",
"__KEY_query",
"__FK_query",
(SELECT
"@Value",
"__FK_distributor"
FROM "distributor" FK "__FK_distributor" ArrayValueAlias "@Value")
FROM "query" PK "__KEY_query" FK "__FK_query"),
(SELECT
"id" AS "id_u4",
"version",
"pid",
"externalId",
"name" AS "name_u4",
"status" AS "status_u0",
"courseType" AS "courseType_u0",
"dateCreated" AS "dateCreated_u0",
"lastUpdated",
"referrer" AS "referrer_u0",
"interestLevel" AS "interestLevel_u0",
"campaign",
"formURL",
"saleGroup" AS "saleGroup_u0",
"isEnabled" AS "isEnabled_u0",
"manager" AS "manager_u0",
"discardReason",
"customStatus" AS "customStatus_u0",
"enrollmentFieldApproved",
"enrollmentFieldCount",
"paymentDueDate",
"paymentStatus" AS "paymentStatus_u0",
"enrollmentStatus" AS "enrollmentStatus_u0",
"__KEY_resourceList",
"__FK_resourceList",
(SELECT
"id",
"name",
"email",
"firstName",
"lastName",
"birthday",
"gender",
"__KEY_client",
"__FK_client",
(SELECT
"number",
"type",
"__FK_phone"
FROM "phone" FK "__FK_phone")
FROM "client" PK "__KEY_client" FK "__FK_client"),
(SELECT
"name" AS "name_u0",
"nationality",
"birthday" AS "birthday_u0",
"occupation",
"firstName" AS "firstName_u0",
"lastName" AS "lastName_u0",
"email" AS "email_u0",
"__FK_student"
FROM "student" FK "__FK_student"),
(SELECT
"id" AS "id_u0",
"name" AS "name_u1",
"email" AS "email_u1",
"iconUri",
"__FK_seller"
FROM "seller" FK "__FK_seller"),
(SELECT
"id" AS "id_u1",
"name" AS "name_u2",
"__FK_distributor_u0"
FROM "distributor" FK "__FK_distributor_u0"),
(SELECT
"departureDate",
"destination",
"interest",
"budget",
"channel" AS "channel_u0",
"comments",
"dateCreated",
"reporter",
"__FK_lead"
FROM "lead" FK "__FK_lead"),
(SELECT
"id" AS "id_u2",
"name" AS "name_u3",
"__FK_customStatus"
FROM "customStatus" FK "__FK_customStatus"),
(SELECT
"id" AS "id_u3",
"start",
"__FK_saleOrder"
FROM "saleOrder" FK "__FK_saleOrder")
FROM "resourceList" PK "__KEY_resourceList" FK "__FK_resourceList")
FROM JSON (wrap on) "root" PK "__KEY_root";

Labels (5)
1 Reply
Partner
Partner

Re: Convert JSON to QVD

Store RestConnectorMasterTable into [lib://QVD/RestConnectorMasterTable.qvd](qvd);

Where lib://QVD = the desired Folder Data Connection.

Blog: WhereClause   Twitter: @treysmithdev