Binary

[hafaneh]

Binary [APP ID];

how can i use this in the app to take data from another app like 
i want the qvd i have to take 2023 only data
and the app im taking its bunary id to take only 2022 

how can i do this ? 

[Chanty4u]

try this

Binary [APP ID];

2022Data:
LOAD *
FROM [binary load of [APP ID].qvd]
(qvd)
WHERE Year = 2022; 

[steeefan]

Load your app BINARY (very first row of script), then load your 2023 data from the QVD file and attach the 2022 data from the relevant table in the app you loaded earlier.

BINARY [APP ID];

// Get 2023 data
Data:
LOAD
  *
FROM
  [lib://your_path/Data.qvd]
  (qvd);

// Get 2022 data
CONCATENATE (Data) LOAD
  *
RESIDENT
  TableNameFromBinaryAppLoad
WHERE
  Year = 2022;

DROP TABLES ...;

After that, make sure to DROP all the tables you do not need from the app you loaded BINARY.

[panosalexand]

Hi Hafaneh,

Please try the following in the script Binary c:\qv\yourexample.qvw; (here you will replace within your path where the app is located ). 

Create the binary logic before you load the script. I'd recommend  you to keep it as a different tab next to Main tab.

Thanks