Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Table that's stores questions identified with GUID's instead of the literal questions names I need to translate them using ApplyMap and RENAME
The problem I'm having is how do I translate field names to readable values. I dont know how to map field names to something else.
the manual way to do this would be to alias all the fields....
Mapping_Questions:
Mapping LOAD frmqstnQuestionText,
frmqstnGUID;
SQL SELECT frmqstnQuestionText,
frmqstnName
FROM "master".dbo."QV_QuestionNames";
Form_6248:
LOAD prjrptId,
prjrptProjectId as ProjectID,
prjrptFormId,
prjrptReportID,
prjrptDate,
"Qcabd5f36_9b83_46b8_a510_57921949b40b",
"Q0a3bbcfd_456b_414c_93bc_64a65a3aa880",
"Q02ccee4f_c1d4_46d2_b925_82c744287c04",
"Q61f58659_e530_4188_b3a0_1cd9e00a06d1",
"Qfd25bad3_13cc_42a8_99a6_6a18fcf83c32",
"Q95e48c02_3bf0_4b78_abc4_8b7708a2720";
SQL SELECT prjrptId,
prjrptProjectId,
prjrptFormId,
prjrptReportID,
prjrptDate,
"Qcabd5f36_9b83_46b8_a510_57921949b40b",
"Q0a3bbcfd_456b_414c_93bc_64a65a3aa880",
"Q02ccee4f_c1d4_46d2_b925_82c744287c04",
"Q61f58659_e530_4188_b3a0_1cd9e00a06d1",
"Qfd25bad3_13cc_42a8_99a6_6a18fcf83c32",
"Q95e48c02_3bf0_4b78_abc4_8b7708a2720"
FROM "master".dbo."vw_6248";
ok, makes sense. done. How do I prevent the other non GUID fields from being renamed or destroyed when it doesn't find a match ? Is there a way to exclude them?
I think using will help but the site example doesnt match my situation in this regard does it?
WHERE len(??????? )>0;
Maybe you dont need it
All is well. Your right. Its seems like some GUIDs did not have a match so it was making it look like it was messing with other fields.
Thanks
Please subcribe to my Youtube page for Qlikview Tutorials
https://www.youtube.com/user/RustyFishBones
They can help, sometimes but not all the time
Regards
Alan
Will do. Thanks!