Urgent Binary Load Issue

[#1]

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

[hector_munoz]

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

[#3]

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]

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

[#5]

Hi vinieme12

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

Thanks

[vinieme12]

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

[MarcoWedel]

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

regards

Marco

[#8]

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 · Accepted solution]

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

[#10]

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

Sorted it out.

Regards