Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ........
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
thanks for reply,
path is correct ,sheet name is correct only
no error while loading
Hey..
Is it possible to share your qvw file and source file?
BR,
Chinna