Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2015-04-04 04:59 AM

interview quetion

name            tool

naveen         qlikview,tableu

purush          infruamatica,msbi

i want these table like as(split tool)

naveen        qlikview

naveen         tableu

purush          infruamatica

purush          msbi

for examle

naveen        qlikview

naveen         tableu

purush          infruamatica

purush          msbi


if we use AGGR function for this we can get first table

what is the opposite funtion for AGGR

640 Views
0 Likes
1 Solution

Accepted Solutions
Gysbert_Wassenaar
MVP
MVP
‎2015-04-04 05:18 AM

load

     name,

     subfield(tool,',') as tool

from ...


talk is cheap, supply exceeds demand

View solution in original post

491 Views
2 Replies
Gysbert_Wassenaar
MVP
MVP
‎2015-04-04 05:18 AM

load

     name,

     subfield(tool,',') as tool

from ...


talk is cheap, supply exceeds demand
492 Views
Anonymous
Not applicable
‎2015-04-04 05:36 AM
Author

Hi Naveen,

Please check the attachment for solution

subfield.qvw
491 Views