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

[bharani8]

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?

[Anil_Babu_Samineni]

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 ;

[bharani8]

i see script error.. Garbage after statement

[Anil_Babu_Samineni · Accepted solution]

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 ;

[bharani8]

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

[Anil_Babu_Samineni]

Why not?

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

[bharani8]

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

[Anil_Babu_Samineni]

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

[PrashantSangle]

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

Regards,

Prashant

[arvind_patil]

Me too.