tesst

[dnowebdn]

Hi,

I would like to have a solution on the follwing scenario

[petter · Accepted solution]

Here is a solution actually:

T:
LOAD
    Module,
    Team AS Team_,
    Subject AS Subject_
FROM [LIB://DATA/Multiple Lines in Excel Cell into Multiple Rows in Qlik Sense.xlsx]
(ooxml, embedded labels, table is Multiline);

T_Lines:
LOAD
  Module,
  If( Peek('Module')=Module, Peek('R#')+1, 1) AS R#,
  SubField(Team_,Chr(10)) AS Team
RESIDENT
  T;

OUTER JOIN 

LOAD
  Module,
  If( Peek('Module')=Module, Peek('R#')+1, 1) AS R#,
  SubField(Subject_,Chr(10)) AS Subject
RESIDENT
  T;

T_LINES:
NOCONCATENATE LOAD
  Module,
  R#,
  If( IsNull(Team) , '' , Team) AS Team,
  If( IsNull(Subject) , '' , Subject) AS Subject
RESIDENT
  T_Lines
ORDER BY
  Module,R#;

DROP TABLE T_Lines;
DROP FIELDS Team_,Subject_;

[dnowebdn]

Hi

i tried however i coulnot acheive 100% with my data.
can you please help check

[dnowebdn]

Forslag petter-s?