Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Xolink1389
Creator
Creator

Separate data in rows

Hello i have this problems, the content of this sheet is like this

Xolink1389_0-1712763860870.png
the column CAMPOS contain the info separate with space, but i want when qlik read it, be like record in a row like this:

EBELN
EBELP
BANFN
BNFPO
INFNR
MATNR
WERKS
BUKRS

and not like this

BSTYP PSTYP LGORT MTART EBELN ABDAT VOLUM VOLEH BWTAR KNTTP ELIKZ PEINH MENGE MEINS BPRME NETPR WEPOS REPOS TXZ01 INFNR BEDNR BWTTY EADAT BNFPO LOEKZ TWRKZ EMLIF IDNLF BANFN BRGEW NTGEW BPUMZ BPUMN INSMK STATU ABELP NETWR LMEIN EREKZ BRTWR MAHN1 MAHN2 MAHN3 ABSKZ MAHNZ KTMNG SPING ABMNG GEWEI GNETWR STATUS DPTYP DPAMT DPPCT SOBKZ KZVBR ZWERT BRTWR KONNR PACKNO

its posible?


 

Labels (4)
1 Reply
BrunPierre
Partner - Master
Partner - Master

Like this.

SubField(CAMPOS, ' ') as CAMPOS