Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
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
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
wouldn't this load just create a table named "Add" based on the Add.qvd filename if not specified otherwise?
regards
Marco
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
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
Thank you all for your contributions/solutions/suggestions and time. I really appreciate.
Sorted it out.
Regards