topic Re: How to load multiple lines into the same rows using load * Inline in QlikView

How to load multiple lines into the same rows using load * Inline

Thu, 14 Jan 2016 10:50:59 GMT

Hi All,

How to create a field with multiple lines in the same row using load * inline.

For example

I want to create something like following:

I want to create the following log table

Row	Date	Shopping List
1	2016/01/01	Started creating the application
2	2016/01/02	Added the following reports: - Customer Contact Listing - Sales Contact Listing - Sale Contact customer frequency
3	2016/01/03	Added the following dashboard - This Audit Log table to keep track the changes of the application - Customer Order report - Customer Revenue generated report

Row

Date

Shopping List

2016/01/01

Started creating the application

2016/01/02

Added the following reports:

- Customer Contact Listing

- Sales Contact Listing

- Sale Contact customer frequency

2016/01/03

Added the following dashboard

- This Audit Log table to keep track the changes of the application

- Customer Order report

- Customer Revenue generated report

Do you know how can I insert special characters like new line or tab into the report?

Thanks in advance.

Re: How to load multiple lines into the same rows using load * Inline

sunny_talwar — Thu, 14 Jan 2016 19:15:54 GMT

Try this:

Table:

LOAD F1,

F2,

Evaluate(F3) as F3

INLINE [

F1, F2, F3

1, 2016/01/01, "'Started creating the application'"

2, 2016/01/02, "'Added the following reports:' & Chr(10) & '- Customer Contact Listing' & Chr(10) & '- Sales Contact Listing' & Chr(10) & '- Sale Contact customer frequency'"

3, 2016/01/03, "'Added the following dashboard' & Chr(10) & '- This Audit Log table to keep track the changes of the application' & Chr(10) & '- Customer Order report' & Chr(10) & '- Customer Revenue generated report'"

];

Re: How to load multiple lines into the same rows using load * Inline

maxgro — Thu, 14 Jan 2016 19:43:15 GMT

or maybe using some replace, in the example @@ for newline; replace can be nested

Table:

LOAD F1,

F2,

replace(F3, '@@', chr(10)) as F3

INLINE [

F1, F2, F3

1, 2016/01/01, Started creating the application

2, 2016/01/02, Added the following reports: @@ - Customer Contact Listing @@ - Sales Contact Listing @@ - Sale Contact customer frequency

3, 2016/01/03, Added the following dashboard @@ - This Audit Log table to keep track the changes of the application @@ - Customer Order report @@ - Customer Revenue generated report

];

Re: How to load multiple lines into the same rows using load * Inline

Thu, 14 Jan 2016 22:04:26 GMT

Sunny and Maxgro,

Thanks for all your response.

I tried both and both answer is correct. Maxgro, as your solution appears easier to use, I used your solution.

Thanks!

Re: How to load multiple lines into the same rows using load * Inline

Thu, 14 Jan 2016 22:10:49 GMT

Sunny,

Your solution also inspired me how to solve my other problem in a better way.

A Big Thanks You to you!

Re: How to load multiple lines into the same rows using load * Inline

sunny_talwar — Thu, 14 Jan 2016 23:13:46 GMT

Great, I am glad we were able to help you resolve your problem. In the process I learned a new technique of doing this from maxgro‌. So thanks to you and Maxgro as well