I am learning Qlik Sense and so as a result I tend to hop between Data Manager and Data Load Editor - I find Data Manage useful to help with adding fields etc when I am not clear on syntax.
What I do find though is that Qlik is creating an Auto Genrated Script and including things which appear to be working perfectly well. For example:
I have a country field in my load script and have included:
__countryAliasesBase:
LOAD
Alias AS [__Country],
ISO3Code AS [__ISO3Code]
FROM [lib://Live - ProvePrivacy:DataFiles/countryAliases.qvd]
(qvd);
__countryGeoBase:
LOAD
ISO3Code AS [__ISO3Code],
ISO2Code AS [__ISO2Code],
Polygon AS [__Polygon]
FROM [lib://Live - ProvePrivacy:DataFiles/countryGeo.qvd]
(qvd);
__countryName2IsoThree:
MAPPING LOAD
__Country,
__ISO3Code
RESIDENT __countryAliasesBase;
__countryCodeIsoThree2Polygon:
MAPPING LOAD
__ISO3Code,
__Polygon
RESIDENT __countryGeoBase;
As well as:
APPLYMAP( '__countryCodeIsoThree2Polygon', APPLYMAP( '__countryName2IsoThree', LOWER([overseas_country])), '-') AS [international_safegaurds.overseas_country_GeoInfo];
SELECT
id,
`international_safegaurds_description`,
`overseas_country`,
...
...
...
FROM `db`.`international_safegaurds`;
APPLYMAP( '__countryCodeIsoThree2Polygon', APPLYMAP( '__countryName2IsoThree', LOWER([overseas_country])), '-') AS [international_safegaurds.overseas_country_GeoInfo];
SELECT
id,
`international_safegaurds_description`,
`overseas_country`,
`overseas_privacy_sheild`,
`overseas_Safegaurd`,
`overseas_Safegaurd_Exception`,
`overseas_owner`,
// `overseas_expiry`,
`overseas_freequency`,
`overseas_volume`,
`overseas_compelling`,
`overseas_advised`,
file,
status,
`document_purpose`,
`document_location`
// `data_sharing_id`
FROM `prove_privacy`.`international_safegaurds`;
TAG FIELD [overseas_country] WITH '$geoname', '$relates_international_safegaurds.overseas_country_GeoInfo';
TAG FIELD [international_safegaurds.overseas_country_GeoInfo] WITH '$geopolygon', '$hidden', '$relates_overseas_country';
However if I open Data Manager the auto generated script is added and the country GeoInfo field is re added appended with a '_1' e.g.
TAG FIELD [international_safegaurds.overseas_country_GeoInfo_1] WITH '$geopolygon', '$hidden', '$relates_overseas_country';
Is there a reason why this keeps happening?
Very frustrating.
