topic Re: Filling data on nulled dimensions with the first row data in QlikView

Filling data on nulled dimensions with the first row data

AB-mx — Sat, 16 Nov 2024 19:34:59 GMT

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 On	Summary	Acct Code	Client ID
563827	1	20170110	FFA - INVOICE - SUPPLIER	50601001	100130
563827	5	20170110	FGI - TRANSFER - SUPPLIER, GAIN	506099111111	-
563828	1	20170110	FFA - INVOICE - SUPPLIER	50601001	101115
563828	3	20170110	FGI - TRANSFER -	506099111111	-

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

Arthur_Fong — Thu, 28 Nov 2019 07:37:50 GMT

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;

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

Brett_Bleess — Mon, 09 Dec 2019 22:25:09 GMT

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