Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
AB-mx
New 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
Partner
Partner

Re: Filling data on nulled dimensions with the first row data

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;

Support
Support

Re: Filling data on nulled dimensions with the first row data

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 don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.