Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a data set provided as below
Person | Location | Month | Sales |
Bob | London | Jan | 100 |
New York | Feb | 200 | |
London | Mar | 300 | |
Kate | New York | Jan | 400 |
London | Feb | 500 | |
London | Mar | 600 | |
John | New York | Jan | 100 |
Mark | London | Feb | 200 |
All i need to do is fill the person name in the blank column in qlik.
Kindly suggest a way.
load If(len(trim(Person))=0,peek(Person),Person) as Person , Location, Month ,Sales Inline [ Person ,Location, Month ,Sales Bob ,London ,Jan ,100 ,New York ,Feb, 200 ,London, Mar, 300 Kate, New York, Jan, 400 ,London ,Feb ,500 ,London ,Mar, 600 John ,New York ,Jan, 100 Mark, London, Feb ,200 ];
load If(len(trim(Person))=0,peek(Person),Person) as Person , Location, Month ,Sales Inline [ Person ,Location, Month ,Sales Bob ,London ,Jan ,100 ,New York ,Feb, 200 ,London, Mar, 300 Kate, New York, Jan, 400 ,London ,Feb ,500 ,London ,Mar, 600 John ,New York ,Jan, 100 Mark, London, Feb ,200 ];