dynamic filter in script

[beck_bakytbek]

Hi Folks,

i have a question:

my script does look like

load

ID,

Variante,

Category

from.....

Field: Category has only 2 Values: 1 and 2

i want to achieve a situation, where i load my dates where only Category = 1, I know i can solve that with: where Caterory = 1, but i want ti know whether is that makeable with variable:

is that possible with variable?

thanks a lot

beck

[PrashantSangle]

Hi,

various way to achieve it.

1:

maintain excel which have filter fields and value.

then in Load first load excel table then load your table with where exists()

Excel:

Load Category from excel;

QVD;

Load * from table where exists(Category)

2: Using variable

Pass value to variable in batch (for that you have little knowledge on windows command or google )

Regards,

Prashant

[beck_bakytbek]

Prashant Thanks a lot for your feedback

[beck_bakytbek]

Hi Shiva, thanks a lot for your feedback,

can you show me your example of this issue?

thanks