records or not updating?

[#1]

Hi experts ,

i have a source file  XL  in that  i have 2 fields

Sourcefile:

path,amount

\\abc\cd,100

\\bcd\cd,200

\\dhi\sd,300

i have loaded this  and mapped with one table like written

table2:

num#(applymap('Sourcefile',path) -[pending amount]  as new amount

after  few days i have added a new records in sourcefile like

path,amount

\\abc\cd,100

\\bcd\cd,200

\\dhi\sd,300

\\jhk\rt,400

\\ewd\as,500

here the problem is after excution of apply map  statement  i cant see my new cords(old records showing) ?

what is the problem  here?

pls give me some idea ........

[Anonymous]

Hi Manoj,

Could be below resons

I think your qvw file is reffering the old file path . Check the file path/directory in script is reffering.

Also check the sheet name in you source file.

while reloading if you are not getting any problem then it should be issue with File path should be the problem.

Also try with a inline table and check your script. that willgive you more clue in debug.

BR,

Chinna

[#3]

thanks for reply,

path is correct ,sheet name is correct only

no error while loading

[Anonymous]

Hey..

Is it possible to share your qvw file and source file?

BR,

Chinna