Binary Load: Can't we provide where clause in it?

[#1]

Guys,

Is that possible to write WHERE Condition for Binary Load?

Also can we write IF ELSE Conditions?

IF v6months THEN

BINARY C:\6MonthsData.qvw;

ELSE

BINARY C:\12MonthsData.qvw;

END IF;

[ramoncova06]

you could do the following for your fact,

Binary Sales_Report.qvw;

tempdate:

right keep (FT)

load distinct

DATE

resident  FT

where DATE >= '$(vSixMonths)';

drop table tempdate;

I didn't tested but I have done something similar before, so it should work

For the dimensions table do you really need to drop the unwanted older data ?

if you do then you need to do something similar to what was done for FT, just identify the key fields after the FT right keep

[ramoncova06]

as far as I know partial reload is to update some specific tables, I am not sure if it works with a binary load, since I have never tried combining them

[#4]

BINARY C:\DATA_12_MONTHS.qvw;

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

FACT_DATA_1:

LOAD *

RESIDENT FACT_DATA

WHERE DateKey= 20150301;

DROP TABLE FACT_DATA;

Hey Guys,

What is wrong with above script?

DATA_12_MONTHS.qvw having a fact table FACT_DATA with 12 months data and I am trying to reduce it to one day data and load into FACT_DATA_1. But this is not working as expected.

1-It is not creating table FACT_DATA_1..?

2- WHERE DateKey= 20150301 filter is not working?

[saumyashah90]

i m stuck wit same problem

[tamilarasu]

Saumya,

Create a new thread and explain your issue. You might get responses quickly.

[flipside]

I agree with Tamil, a new thread might be best, but if your problem is the same as the original question here, what you can do with a binary load is call an external script ...

binary $(Must_Include=file.txt);

... with file.txt simply holding the name (& path if needed) of the qvw you want to binary load. You just need to find a way of creating this file, it could be a store command in a previous qvw reload, or an export from an object via a macro, maybe.

Hope this helps.

[Anonymous]

Try a NoConcatenate before your LOAD *

It is likely that it is concatenating to the original FACT_DATA as the fields will be exactly the same.

[ronnywaage]

‌hi

i am not sure if this is still an issue but the way i have solvendt the original question here is to use include files for the binare load or other alternative loads. Then i keep a variable with the name of the file to use for the load e.g. Load-bin-A.qvs and load-bin-B.qvs