Hi!
In my Load Data Editor , I have this code:
Section Access;
USER_LANGUAGE:
LOAD
"USERID",
LANGUAGE
FROM [lib://I18n /user_configuration.xlsx]
(ooxml, embedded labels, table is Language);
USER_COMPANY:
LOAD
"USERID",
COMPANY
FROM [lib://I18n /user_configuration.xlsx]
(ooxml, embedded labels, table is Company);
USER_SITE:
LOAD
"USERID",
SITE
FROM [lib://I18n /user_configuration.xlsx]
(ooxml, embedded labels, table is Site);
USER_TEMP:
LOAD 'USER' as "ACCESS", * RESIDENT USER_LANGUAGE;
JOIN
LOAD * RESIDENT USER_COMPANY;
JOIN
LOAD * RESIDENT USER_SITE;
USERS:
LOAD
"ACCESS",
"USERID",
LANGUAGE,
COMPANY & '-' & SITE AS COMPANY_SITE
RESIDENT USER_TEMP;
DROP TABLE USER_LANGUAGE;
DROP TABLE USER_COMPANY;
DROP TABLE USER_SITE;
DROP TABLE USER_TEMP;
Section Application;
In my excel, i have this datas:
User Language
Domínio/f.borges PT
When i used PT for portuguese language, created a row for each language.
When i used EN for english languade, created a row only english language.
Tks for your reply.
