Load only few values of an column.. not all

[bharani8]

Hi Experts - I have a below data

Fruits

Apple

Orange

Grape

Mango

Banana

I just need to load Apple & Grape alone.. Please help me how can i get this..

[PrashantSangle]

Hi,

You can use wildmatch() in where clause

like

Load * from TableName

where wildmatch(FieldName,'Apple','Grape');

Regards

[Anil_Babu_Samineni]

Like this?

Load * From Table Where Match(Fruits, 'Apple', 'Grape');

In front end you can use expression as

If(Match(Fruits, 'Apple','Grape'), Fruits)

Note - You will get bulk posts related this? You may start this in community

[PrashantSangle]

Or If there are multiple value for that you want to restrict data then maintain a mapper file which contain only those value which you want to display and In your final table use where exist()

Like

mapper:

Load * INLINE [

Fruit

Apple

Grape

];

NoConcatenate

FinalTable:

Load * from YourTableName

where exists(Fruit,Fruit);

Regards

[arvind_patil]

Hi Bharani,

You can use Code Like Below:

T:

Load * Inline [

Fruits

Apple

Orange

Grape

Mango

Banan];

NoConcatenate

FinalTable:

LOAD *

Resident T

Where WildMatch(Fruits,'Apple','Grape');

Drop Table T;

Thanks,

Arvind Patil

[bharani8]

Am new to this tool.. Can u share how this is done in the script after loading a sample table please.. I know to do it in Front end.. but not while loading the data itself

[bharani8]

Am new to this tool.. Can u share how this is done in the script after loading a sample table please.. I know to do it in Front end.. but not while loading the data itself

[bharani8]

Am new to this tool.. Can u share how this is done in the script after loading a sample table please.. I know to do it in Front end.. but not while loading the data itself

[arvind_patil]

HI Bharani,

Please check above script;

Thanks ,

Arvind Patil

[Anil_Babu_Samineni]

Nothing new, This works as Where condition in SQL / Any DB. Let's consider as your data set

LOAD * Inline [

Fruits

Apple

Orange

Grape

Mango

Banana

] Where Match(Fruits, 'Apple', 'Grape');

What we are doing here is we have DB data sent in that we need to figure it out which values you need  by help of Wildmatch for showing them we are using Where condition

If you want, More info related WildMatch look at wildmatch ‒ QlikView