it`s my query in sql
SELECT
assets.id,
assets.label,
assets.vin,
assets.client_group,
assets.`status`,
assets_points.check_status,
assets_points.check_datetime,
assets_points.point_id,
cat_points.label,
cat_forms_points.section_id,
cat_forms.label AS cat_form_tipo,
assets.org_id,
assets.updated_at,
assets.created_at,
workshops.sigo_id
FROM
assets
INNER JOIN assets_forms ON assets_forms.asset_id = assets.id
INNER JOIN cat_forms ON cat_forms.id = assets_forms.form_id
INNER JOIN assets_points ON assets_points.asset_form_id = assets_forms.id
INNER JOIN cat_points ON assets_points.point_id = cat_points.id
INNER JOIN assets_points_data ON assets_points_data.asset_point_id = assets_points.id
INNER JOIN assets_points_latest ON assets_points_latest.asset_form_id = assets_forms.id
AND assets_points_latest.asset_id = assets.id
AND assets_points_latest.point_id = cat_points.id
INNER JOIN cat_forms_points ON cat_forms_points.form_id = cat_forms.id
AND cat_forms_points.point_id = cat_points.id
INNER JOIN workshops ON assets.wksp_id = workshops.id
it`s my query in qlik, but i don`t do it
assets:
load id as assets_id, wksp_id as workshops_id
FROM [lib://DataFiles/assets.xls](biff, embedded labels, table is Sheet1$);
assets_forms:
inner join(assets)
load id as assets_forms_id,
asset_id as assets_id ,
form_id as cat_form_id
FROM [lib://DataFiles/assets_forms.csv] (txt, utf8, embedded labels, delimiter is ',', msq);
cat_forms:
Inner join(assets)
load id as cat_form_id FROM [lib://DataFiles/cat_forms.xls](biff, embedded labels, table is Sheet1$);
assets_point:
inner join (assets)
load id as assets_point_id,
asset_form_id as assets_forms_id
,point_id as cat_point_id
from [lib://DataFiles/assets_points.csv] (txt, utf8, embedded labels, delimiter is ',', msq);
cat_points:
inner join (assets)
load id as cat_point_id FROM [lib://DataFiles/cat_points.xls](biff, embedded labels, table is Sheet1$);
assets_points_data:
inner join (assets)
load asset_point_id as assets_point_id FROM [lib://DataFiles/assets_points_data.csv] (txt, utf8, embedded labels, delimiter is ',', msq);
