Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

kshitijas
New Contributor III

Qs- loading data elements from excel

Hello everyone,

                        I have a query regarding how to load column that has three different data elements in one column in an excel and want to extract those elements differently in qliksense . how do i do that?

Thanks and Regards,

Kshitija

Tags (1)
2 Replies
Not applicable

Re: Qs- loading data elements from excel

Maybe The Generic Load can help

brunobertels
Valued Contributor

Re: Qs- loading data elements from excel

Hi

What are the data like in your column ?

Does they get a separator like / or ; or whatever ?

You should share a piece of example of what your excell column look like

for example , if your excell column named My_column get this kind of data :

John / 28 / Seatle ( where you have a name , an age , and town for example ) and you want 3 columns for each value

You can use this function :

SubField(text, delimiter[, field_no ])

SubField(My_Column, '/', 1) as Name,

SubField(My_Column, '/', 2) as Age,

SubField(My_Column, '/', 3) as Town,

Hope it helps

Bruno