alternative to peek function?

Mon, 23 Jun 2014 15:17:47 GMT

Hello community,

I have a bunch of files saved in a directory. I load them into a QV table - one by one - using For Each Next script

The QV table looks like the sheet called fac in the attached file. I would like the QV table to look like end result sheet in the attached file.

As you can see, the value in the field Codes is repeated for all imported codes, where Asset value = 'Yes' (eg Code 1, Code 3 and Code 4)

I was thinking to use the peek function as suggested in this post<http://community.qlik.com/message/429985#429985>, however it is not working for me?

Could you please advise. Thank yof or reading and happy to give you more information if necessary.

Regards, Andrea

*********************************************************************************

Severn Trent Plc (registered number 2366619) and Severn Trent Water Limited

(registered number 2366686) (together the "Companies") are both limited companies

registered in England & Wales with their registered office at Severn Trent Centre,

2 St John's Street, Coventry, CV1 2LZ

This email (which includes any files attached to it) is not contractually binding on its

own, is intended solely for the named recipient and may contain CONFIDENTIAL,

legally privileged or trade secret information protected by law. If you have received

this message in error please delete it and notify us immediately by telephoning

+44 2477715000. If you are not the intended recipient you must not use, disclose,

distribute, reproduce, retransmit, retain or rely on any information contained in this

email. Please note the Companies reserve the right to monitor email communications

in accordance with applicable law and regulations.

To the extent permitted by law, neither the Companies or any of their subsidiaries,

nor any employee, director or officer thereof, accepts any liability whatsoever in

relation to this email including liability arising from any external breach of security or

confidentiality or for virus infection or for statements made by the sender as these

are not necessarily made on behalf of the Companies.

Reduce waste! Please consider the environment before printing this email.

Re: alternative to peek function?

vgutkovsky — Mon, 23 Jun 2014 21:57:03 GMT

How about a simple keyless join? Assuming your current table is named Data, then:

JOIN (Data) LOAD DISTINCT

Code as MyCode1

RESIDENT Data

Where Asset='Yes'

;

Regards,

Vlad

Re: alternative to peek function?

vgutkovsky — Wed, 25 Jun 2014 21:21:21 GMT

Andrea, as a friendly reminder, please mark all correct answers when on the QlikCommunity forums.

Best regards,

Vlad

Re: alternative to peek function?

Fri, 27 Jun 2014 14:53:42 GMT

Vlad, thank you and apologies for late reply.

I have used your script and edit it a little. I join ID olumn instead to get the end result as shown in the attahement.

Regards, Andrea

topic Re: alternative to peek function? in QlikView

alternative to peek function?

Re: alternative to peek function?

Re: alternative to peek function?

Re: alternative to peek function?