Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to have a solution on the follwing scenario
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_;
Hi
i tried however i coulnot acheive 100% with my data.
can you please help check
Forslag petter-s?