Tag for any articles discussing loading and transforming data.
This article will cover the syntax of the 'Section' regular script statement. This statement specified whether the subsequent Load or Select statements are for data or access rights. This is…
This article will cover the syntax of the 'Rename Table' regular script statement. This statement allows specified tables to be renamed. Statement syntax Table | TablesSingle or multiple tables can…
This article will cover the syntax of the 'Rename Field' regular script statement. This statement allows specified fields to be renamed. Statement syntax Field | FieldsSingle or multiple fields can…
This article will cover the syntax of the 'Qualify' regular script statement. Using this statement adds a prefix matching the table name to the fields specified. Statement syntax FieldlistA comma…
This article will cover the syntax of the 'NullAsNull' regular script statement. This statement stops the conversion of NULL values as previously specified using the NullAsValue statement. Statement syntax FieldlistA…
This article will cover the syntax of the 'NullAsValue' regular script statement. This statement converts NULL values in given fields to specific values. This can be particularly useful for using…
This article will cover the syntax of the 'map' regular script statement. The map statement is used with a mapping table. It's a way to map specific field values to…
This article will cover the syntax of the 'loosen table' regular script statement. The loosen table statement is used to force Qlik to isolate specific fields in a table in…
This article will cover the syntax of the 'load' regular script statement. The load statement is used to load data into the Qlik Sense app. The syntax of the statement…
This article will cover the syntax of the 'force' regular script statement. The force statement is used to force Qlik Sense to read subsequently specified field names in a specific…