topic Re: Load only few values of an column.. not all in QlikView

Load only few values of an column.. not all

bharani8 — Wed, 25 Nov 2020 16:16:04 GMT

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..

Re: Load only few values of an column.. not all

PrashantSangle — Tue, 04 Jul 2017 06:42:39 GMT

Hi,

You can use wildmatch() in where clause

Load * from TableName

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

Regards

Re: Load only few values of an column.. not all

Anil_Babu_Samineni — Tue, 04 Jul 2017 06:43:36 GMT

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

Re: Load only few values of an column.. not all

PrashantSangle — Tue, 04 Jul 2017 06:45:39 GMT

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()

mapper:

Load * INLINE [

Fruit

Apple

Grape

];

NoConcatenate

FinalTable:

Load * from YourTableName

where exists(Fruit,Fruit);

Regards

Re: Load only few values of an column.. not all

arvind_patil — Tue, 04 Jul 2017 06:46:39 GMT

Hi Bharani,

You can use Code Like Below:

Load * Inline [

Fruits

Apple

Orange

Grape

Mango

Banan];

NoConcatenate

FinalTable:

LOAD *

Resident T

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

Drop Table T;

Thanks,

Arvind Patil

Re: Load only few values of an column.. not all

bharani8 — Tue, 04 Jul 2017 07:21:19 GMT

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

Re: Load only few values of an column.. not all

bharani8 — Tue, 04 Jul 2017 07:23:50 GMT

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

Re: Load only few values of an column.. not all

bharani8 — Tue, 04 Jul 2017 07:24:08 GMT

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

Re: Load only few values of an column.. not all

arvind_patil — Tue, 04 Jul 2017 07:26:53 GMT

HI Bharani,

Please check above script;

Thanks ,

Arvind Patil

Re: Load only few values of an column.. not all

Anil_Babu_Samineni — Tue, 04 Jul 2017 07:28:37 GMT

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

Re: Load only few values of an column.. not all

bharani8 — Tue, 04 Jul 2017 07:31:54 GMT

My Data in script is like

LOAD SALES_PROD_W_OPTION_NR,

PART_DN,

LOCAL_STD_COST_AM,

ISO_CURRENCY_CD,

CURRENCY_RATE,

USD_STD_COST_AM,

PRODUCT_LINE_CD,

PROD_LINE_NM,

FRUIT

FROM

C:\Users\Public\Desktop\Reports\CSV_Files\WW_IPG_INVENTORY_WEEKLY_HISTORY.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

STORE IPG_Inventory INTO ;

Where will i use that now?

Re: Load only few values of an column.. not all

Anil_Babu_Samineni — Tue, 04 Jul 2017 07:36:54 GMT

try here

LOAD SALES_PROD_W_OPTION_NR,

PART_DN,

LOCAL_STD_COST_AM,

ISO_CURRENCY_CD,

CURRENCY_RATE,

USD_STD_COST_AM,

PRODUCT_LINE_CD,

PROD_LINE_NM,

FRUIT

FROM

C:\Users\Public\Desktop\Reports\CSV_Files\WW_IPG_INVENTORY_WEEKLY_HISTORY.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq) Wildmatch(field, 'value1','value2');

STORE IPG_Inventory INTO ;

Re: Load only few values of an column.. not all

bharani8 — Tue, 04 Jul 2017 07:43:56 GMT

i see script error.. Garbage after statement

Re: Load only few values of an column.. not all

Anil_Babu_Samineni — Tue, 04 Jul 2017 07:47:43 GMT

My bad, Missed Where condition

LOAD SALES_PROD_W_OPTION_NR,

PART_DN,

LOCAL_STD_COST_AM,

ISO_CURRENCY_CD,

CURRENCY_RATE,

USD_STD_COST_AM,

PRODUCT_LINE_CD,

PROD_LINE_NM,

FRUIT

FROM

C:\Users\Public\Desktop\Reports\CSV_Files\WW_IPG_INVENTORY_WEEKLY_HISTORY.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq) Where Wildmatch(field, 'value1','value2');

STORE IPG_Inventory INTO ;

Re: Load only few values of an column.. not all

bharani8 — Tue, 04 Jul 2017 07:49:27 GMT

Yes i got hat now... What if i need to do same for one more field?

Re: Load only few values of an column.. not all

Anil_Babu_Samineni — Tue, 04 Jul 2017 07:50:47 GMT

Why not?

Where Wildmatch(field, 'value1','value2') and WildMatch(field1, 'value1','value2')

Re: Load only few values of an column.. not all

bharani8 — Tue, 04 Jul 2017 07:52:36 GMT

Thanks a lot for taking your precious time to explain this!! Appreciate it!!

Re: Load only few values of an column.. not all

Anil_Babu_Samineni — Tue, 04 Jul 2017 07:56:13 GMT

I would suggest you to Buy Cook book, This may helps you lot and lot as i feel

Note - Please mark as Helpful over thread that may helps for next landing persons

Re: Load only few values of an column.. not all

PrashantSangle — Tue, 04 Jul 2017 08:49:35 GMT

Just for curiosity, What is wrong in my answer???

Regards,

Prashant

Re: Load only few values of an column.. not all

arvind_patil — Tue, 04 Jul 2017 08:58:05 GMT

Me too.