topic Re: Excel join in worksheet where data is grouped in QlikView

Excel join in worksheet where data is grouped

Anonymous — Tue, 11 Feb 2014 17:52:21 GMT

Good day,

I have a workbook that I would like to join (ETN) based on one field in a worksheet. The format within the sheet is grouped so the related information appears to the typical join as blank. My guess is I need some scripting upon the load, but not sure how to do it. I have attached an example of a limited amount of data. Any thoughts or ideas would be much appreciated.

Re: Excel join in worksheet where data is grouped

Gysbert_Wassenaar — Tue, 11 Feb 2014 18:13:24 GMT

See attached qvw. Is that what you need?

Re: Excel join in worksheet where data is grouped

Anonymous — Tue, 11 Feb 2014 18:49:46 GMT

unfortunately I don't have purchased licence yet so I can' see your script in Qlikview

Re: Excel join in worksheet where data is grouped

Nicole-Smith — Tue, 11 Feb 2014 19:17:43 GMT

Data:

LOAD if(len([1])>0,[1],peek('1')) as [1],

if(len([2])>0,[2],peek('2')) as [2],

if(len([3])>0,[3],peek('3')) as [3],

if(len([6])>0,[6],peek('6')) as [6],

if(len([ETN])>0,[ETN],peek('ETN')) as [ETN]

FROM hierarchy.xlsx

(ooxml, embedded labels, table is Sheet1);

Re: Excel join in worksheet where data is grouped

Anonymous — Tue, 11 Feb 2014 19:38:04 GMT

This is what I needed. Thank you all very much