Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

QSense load and filed name

Hello all,

I'am using Qsense

And I would like to understand why :

SET ThousandSep=' ';
SET DecimalSep=',';
SET MoneyThousandSep=' ';
SET MoneyDecimalSep=',';
SET MoneyFormat='# ##0,00 €;-# ##0,00 €';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';
SET MonthNames='janv.;févr.;mars;avr.;mai;juin;juil.;août;sept.;oct.;nov.;déc.';
SET DayNames='lun.;mar.;mer.;jeu.;ven.;sam.;dim.';
SET LongMonthNames='janvier;février;mars;avril;mai;juin;juillet;août;septembre;octobre;novembre;décembre';
SET LongDayNames='lundi;mardi;mercredi;jeudi;vendredi;samedi;dimanche';
SET FirstWeekDay=0;
SET BrokenWeeks=1;
SET ReferenceDay=0;
SET FirstMonthOfYear=1;
SET CollationLocale='fr-FR';

LIB CONNECT TO 'OTRS Prod';

in_map:
load ticket_id as id, create_time as create_time;
select ticket_id, min(create_time) as create_time
from ticket_history where
history_type_id=16 and (name like "\%\%Hotline\%\%%\%\%%\%\%%" or name like "\%\%D3 Alerts\%\%%\%\%%\%\%%")
group by id;

out_map:
load ticket_id as id, create_time as create_time;
select ticket_id, min(create_time) as create_time
from ticket_history where
history_type_id =16 and (name like "\%\%%\%\%Hotline\%\%%" or name like "\%\%%\%\%D3 Alerts\%\%%")
group by ticket_id;

Give me only one table in_map ?

is it a bug or not ?

if I change the file name to be different is would create me two table ?!!


4 Replies
Employee
Employee

Re: QSense load and filed name

If two load statements have identical output fields, the tables will be concatenated into one table. So, if you want two tables, you should use other aliases for the fields.

HIC

Not applicable

Re: QSense load and filed name

ok thks henric,

so the table table of the load is useless ?

Not applicable

Re: QSense load and filed name

so the table name of the load is useless ?

Employee
Employee

Re: QSense load and filed name

It's not useless but it doesn't influence how the loaded data is stored.

HIC