topic Is it possible to create an inline table with carriage returns in the data? in QlikView

Is it possible to create an inline table with carriage returns in the data?

Mon, 21 Jun 2010 20:57:29 GMT

I need to manipulate some data from our ERP system but am struggling.

For each sales order there can be more than one question and answer.

QandA:

LOAD * INLINE [

Order, Seq, Question, Answer

SO1, 1, What is your name?, Simon

SO1, 2, What is your favourite colour?, Blue

];

I only want to see one line per sales order, with all it's answers and questions.

QandA_v2:

LOAD * INLINE [

Order, Questions(s), Answers(s)

SO1,"What is your name?" & chr(10) & chr(13) & "What is your favourite colour?", "Simon" & chr(10) & chr(13) & "blue"

];

The above will not work as the chr(10) chr(13) are just seen as new rows.

Is there any way I can create a table with carriage returns in the data?

Regards

Mark

Is it possible to create an inline table with carriage returns in the data?

Mon, 21 Jun 2010 21:10:05 GMT

What is the business logic for such data? How are you going to use it for BI analysis?

Is it possible to create an inline table with carriage returns in the data?

disqr_rm — Mon, 21 Jun 2010 21:22:57 GMT

Something like this?


QandA:
LOAD * INLINE [
 Order, Seq, Question, Answer
 SO1, 1, What is your name?, Simon
 SO1, 2, What is your favourite colour?, Blue
];
FinalQ_A:
LOAD Order,
 concat(Question & ':' & Answer, chr(10), Seq) as QandA
RESIDENT QandA
GROUP BY Order;
Drop table QandA;

Is it possible to create an inline table with carriage returns in the data?

Mon, 21 Jun 2010 21:52:39 GMT

Exactly what I needed thanks, seems so simple now

Is it possible to create an inline table with carriage returns in the data?

Mon, 21 Jun 2010 21:53:45 GMT

There is none. The customers export this particular chart to excel and email it to colleague who do not have Qlikview. They want to see all the data at order level.