https://community.qlik.com/t5/Official-Support-Articles/Defining-Data-Models-and-Mappings-for-Pivoting-Data-in-Qlik/ta-p/1724161 <P>Operational systems of record often provide data that is not readily consumable by analytics projects and frequently require complex extract, transform and load (ETL) processing to conform the information into a<BR />standard data warehouse model. One common transformation is to pivot multiple rows into a single row<BR />with multiple columns to provide a flattened data set for analysis. Most ETL technologies provide a capability to perform that transformation when processing data in batch; however, the Qlik Data Integration platform provides methods that support both batch and near real-time pivoting of source data into the data warehouse.</P> <P>This paper provides real-world examples that explain the purpose of a pivoted data set, describes how to model the data structures, and how to implement transformation logic for batch and near real-time processing.</P> Thu, 20 Jan 2022 15:47:41 GMT TimGarrod 2022-01-20T15:47:41Z https://community.qlik.com/t5/Official-Support-Articles/Defining-Data-Models-and-Mappings-for-Pivoting-Data-in-Qlik/ta-p/1724161 <P>This paper provides real-world examples that explain the purpose of a pivoted data set, describes how to model the data structures, and how to implement transformation logic for batch and near real-time processing with the Qlik Data Integration Platform</P> Thu, 20 Jan 2022 15:47:41 GMT https://community.qlik.com/t5/Official-Support-Articles/Defining-Data-Models-and-Mappings-for-Pivoting-Data-in-Qlik/ta-p/1724161 TimGarrod 2022-01-20T15:47:41Z https://community.qlik.com/t5/Official-Support-Articles/Defining-Data-Models-and-Mappings-for-Pivoting-Data-in-Qlik/tac-p/1741060#M5334 <P>Fantastic Content. Thank you Tim.</P> Thu, 03 Sep 2020 16:21:47 GMT https://community.qlik.com/t5/Official-Support-Articles/Defining-Data-Models-and-Mappings-for-Pivoting-Data-in-Qlik/tac-p/1741060#M5334 Reza_Khan 2020-09-03T16:21:47Z