Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone ,
I stuck in the requirement for these tables in Qliksense ,looking for your suggestion
Table beta have list of data for different column but the name of this data column should assign on the basis of the Name present in Table meta i.e. EHYBASPOP should be changed as Total Population and EYHBASHHD as Total Households etc.
If the name of EHYBASPOP is change as XXX in Table meta ,then it should automatically changed in the output table
Table beta :
CODE | GEO | EHYBASPOP | EHYBASHHD | EHYBASHPOP | EHYBAS12P | EHYBAS15P | EHYBAS18P | EHYBAS19P |
A0A1A0 | FSAQ421 | 20 | 30 | 25 | 35 | 55 | 62 | 85 |
M1G3H4 | FSALDU | 50 | 56 | 20 | 25 | 47 | 75 | 78 |
M1G3K4 | FSALDU | 70 | 78 | 30 | 10 | 85 | 42 | 45 |
M3H5Y7 | FSALDU | 60 | 94 | 10 | 45 | 65 | 41 | 43 |
Table meta :
Variable | Description |
CODE | CODE |
GEO | GEO |
EHYBASPOP | Total Population |
EHYBASHHD | Total Households |
EHYBASHPOP | Total Household Population |
EHYBAS12P | Total Population 12 Year Or Over |
EHYBAS15P | Total Population 15 Years Or Over |
EHYBAS18P | Total Population 18 Years Or Over |
EHYBAS19P | Total Population 19 Years Or Over |
Required output
CODE | GEO | Total Population | Total Households | Total Household Population | Total Population 12 Year Or Over | Total Population 15 Years Or Over | Total Population 18 Years Or Over | Total Population 19 Years Or Over |
A0A1A0 | FSAQ421 | 20 | 30 | 25 | 35 | 55 | 62 | 85 |
M1G3H4 | FSALDU | 50 | 56 | 20 | 25 | 47 | 75 | 78 |
M1G3K4 | FSALDU | 70 | 78 | 30 | 10 | 85 | 42 | 45 |
M3H5Y7 | FSALDU | 60 | 94 | 10 | 45 | 65 | 41 | 43 |
It's just:
m: mapping load Variable, Description from Meta;
rename fields using m;
Beside this it might be more suitable to transform the crosstable into a normal data-structure and and using then Meta as an associated table or the description information is joined/mapped to this table:
As in the older thread you replied to, this looks like a standard case of Rename Fields using [table]. The syntax is identical for QlikView and Qlik Sense, I believe.
Hi,
Sorry I am still a bit confused. So you are saying that I need to upload both the meta and beta tables in Qliksense as it is and then use the syntax of rename fields?
Rename Fields (using mapname | oldname to newname{ , oldname to newname })
in this case what table would be mapname, oldname and newname?
Sorry i'm a beginner and really confused. If you can elaborate it would be super helpful.
It's just:
m: mapping load Variable, Description from Meta;
rename fields using m;
Beside this it might be more suitable to transform the crosstable into a normal data-structure and and using then Meta as an associated table or the description information is joined/mapped to this table:
Thank you so much 😀