topic Re: Urgent Binary Load Issue in QlikView

Urgent Binary Load Issue

Sun, 12 Feb 2017 13:08:16 GMT

Please how do I binary load and get specific data into a qvd from a qlikview file script that has multiple load statements with no table names.

LOAD [Report type],

CompCode,

[Financial Statement Item],

[Financial statement item text],

[Financial statement item text] as [Financial statment],

Year,

Month,

Data

FROM

(qvd);

LOAD [Financial Statement Item],

[Financial statement item text],

Year,

Month

FROM

(qvd);

How do I binary load load this file to get data from only the second load statement - .

I do not have the source file.

Thanks

Re: Urgent Binary Load Issue

hector_munoz — Sun, 12 Feb 2017 14:40:20 GMT

Hi Nkwocha,

I am afraid you cannot choose tables in a binary load; you load all the tables in an associative model and later you would have to drop those you do not need anymore.

So, if I were you, I would make the binary load, would identify the one table I need (with ots name) and would drop the rest.

Hope it serves...

Regards,
H

Re: Urgent Binary Load Issue

Sun, 12 Feb 2017 15:08:06 GMT

Hello Héctor Muñoz Martín , thanks for the reply.

But from the script I cannot select any table, talk more of dropping any.

What I actually want to achieve is to extract only data loaded from this excel file.

LOAD [Financial Statement Item],

[Financial statement item text],

Year,

Month

FROM

(qvd);

How do I select just that load statement since it doesn't come with a table name.

It would have been possible via binary load if the load statement was attached to a table.

But here no table name.

Thanks

Re: Urgent Binary Load Issue

vinieme12 — Sun, 12 Feb 2017 15:58:22 GMT

if the table is not named during load the QVD name is assumed.

so if you only want to keep data from Add.QVD;

Binary YOURQVW_withfullpath;

Drop table fs23; // Keeping on Add.QVD data

Re: Urgent Binary Load Issue

Sun, 12 Feb 2017 19:08:47 GMT

Hi vinieme12

I have tried your solution but it brings out the error that 'Table not found'.

Thanks

Re: Urgent Binary Load Issue

vinieme12 — Sun, 12 Feb 2017 19:33:37 GMT

Is this the complete script from your QVW?

I think the table might have been auto concatenated with a previously loaded table..

Just Binary Load the QVW >> Press CTRL + T and see what tables exists in the app , you will see the table names there

Re: Urgent Binary Load Issue

MarcoWedel — Sun, 12 Feb 2017 21:32:14 GMT

wouldn't this load just create a table named "Add" based on the Add.qvd filename if not specified otherwise?

regards

Marco

Re: Urgent Binary Load Issue

Mon, 13 Feb 2017 03:39:09 GMT

Yeah that's true.

But this is the actual script that brought about the curiosity:

LOAD CompCode,

Company,

[Company Name],

[FS Version - FS Version Level 01 (Text)] as [FS Version],

[Financial statement item text],

[Computed Balance],

[Report Type],

[Financial Statement Item No] as [Financial Statement Item],

[Financial statement item text] as [Financial statment],

Year &' NGN' as YearNGN,

Year,

Month,

Data

FROM

[FP\Detailed FP\QV4.qvd]

(qvd)

Where Year <= 2014 and Year >= 2013 and Month = 'December';

NOConcatenate

LOAD [Financial Statement Item],

[Financial statement item text],

Year,

Company,

Month,

Year &' NGN'as YearNGN,

CompCode

FROM

[FP\Detailed FP\Mapplet\GroupDetailed.qvx]

(biff, embedded labels, table is [FP Detailed CON$])

Where Year <= 2014 and Year >= 2013;

So there is already a T table but the second load had a NoConcatenate command before it. It's not supposed to concatenate. I just want the data from [FP\Detailed FP\Mapplet\GroupDetailed.qvx].

Is it possible?

Thanks

Re: Urgent Binary Load Issue

hector_munoz — Mon, 13 Feb 2017 07:56:15 GMT

Hi Nkwocha,

As Vineeth said: Reload the QVW with the binary sentence and after it finishes, press CTRL + T and see what tables exists in the app. You can identify the one you need and, in script, drop all the other tables at the end of itself.

Regards,
H

Re: Urgent Binary Load Issue

Tue, 14 Feb 2017 11:49:09 GMT

Thank you all for your contributions/solutions/suggestions and time. I really appreciate.

Sorted it out.

Regards

Re: Urgent Binary Load Issue

Tue, 14 Feb 2017 12:01:49 GMT

Thank you Marco.

Re: Urgent Binary Load Issue

Tue, 14 Feb 2017 12:04:23 GMT

Thank You Vineeth