Extracting first row within the row from a column

[Anonymous]

Hi,

How to load data from a column when we have multiple rows with in a row.

Example:

Header 1
Name
Steven Joseph Cruz
Alex Yoh Chang Yan
Screw Saw

Output should be:

Header 1
Name
Steven
Alex
Screw

Please help me on this example.

[edg_baltazar]

Hi Noble Raj!

When loading the XLSX on Qlikview , click on the CrossTable option on the wizard, I think this should help you... Regards!

[Anonymous]

Hi,

Here I have multiple rows in each row. Only first row need to be displayed on each row.

[salto]

Hello,

try

LOAD subfield(A, ' ' ,1) as Header

FROM

(ooxml, no labels, table is Source);

Hope this helps.

[#5]

Hi, I Only Load excel file.

attach file.

[#6]

It's great!. But, what if Column A contains a row with Stevie J. and other one con Steve ?

[salto]

Then it will retrieve a row with the string "Stevie" (discarding the "J." after the name) and other row with the string "Steve", since I am considering the blank after the name as the field separator...

[Anonymous]

Hi,

@ernesto

If we put cursor on Alex/Screw then we could see the remaining data.

@Salto

If we have spaces or blank in data then we may not get correct result.

[salto]

Hi Noble Raj,

Would it be possible to use a special character to work as "Name delimiter" in your Excel file?

Something, for example a pipe (|)  that could set Steven J.|Joseph|Cruz so we could:

LOAD subfield(A, '|' ,1) as Header

[Anonymous]

Hi Salto,

No.

Even I tried with new line character '\n'. Do we have any option in Qlikview to handle next line?