Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
AB-mx
Contributor
Contributor

Filling data on nulled dimensions with the first row data

Hello,

i need to fill the rows with null data in Client ID column when Acc.Code=506099111111,

using the Client ID corresponding at the VoucherNo=1 for each Voucher category,

the data are loaded from a Database table ...... please help

Please download the file in attched for the full list , thank you

* Voucher Category Code* Voucher No. Voucher Created OnSummary Acct CodeClient ID
563827120170110FFA - INVOICE - SUPPLIER50601001100130
563827520170110FGI - TRANSFER - SUPPLIER, GAIN506099111111-
563828120170110FFA - INVOICE - SUPPLIER50601001101115
563828320170110FGI - TRANSFER - 506099111111-
2 Replies
Arthur_Fong
Partner
Partner

Try this:

Directory;
Raw:
LOAD
"* Voucher Category Code",
"* Voucher No.",
"* Voucher Created On",
"* Summary",
"* Acct Code",
"Client ID"
FROM [lib://AttachedFiles/clientonBlankCeils.xls]
(biff, embedded labels, table is Sheet1$);


Table:
load *,RowNo()as TotalRow, if(RowNo()=1,[Client ID],if(len([Client ID])= 1 or isnull([Client ID]),peek([Client ID2]),[Client ID])) as [Client ID2]
resident Raw
order by [* Voucher Category Code],
[* Voucher No.];

drop table Raw;

Brett_Bleess
Support (Former)
Support (Former)

Did Arthur's post help you get things working?  If so, please be sure to return to the thread and use the Accept as Solution on his post to give him credit for the assistance and let the other Community Members know it did solve your problem.  If you are still working on things, leave an update on what you need.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.