Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Urgent Binary Load Issue

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

1 Solution

Accepted Solutions
hector_munoz_in
Valued Contributor

Re: Urgent Binary Load Issue

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

11 Replies
hector_munoz_in
Valued Contributor

Re: Urgent Binary Load Issue

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

Not applicable

Re: Urgent Binary Load Issue

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

vinieme12
Esteemed Contributor II

Re: Urgent Binary Load Issue

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

Not applicable

Re: Urgent Binary Load Issue

Hi

vinieme12
Esteemed Contributor II

Re: Urgent Binary Load Issue

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

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

regards

Marco

Not applicable

Re: Urgent Binary Load Issue

Yeah that's true.

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

T:

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

hector_munoz_in
Valued Contributor

Re: Urgent Binary Load Issue

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

Not applicable

Re: Urgent Binary Load Issue

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

Sorted it out.

Regards

Community Browser