source

[raadwiptec]

hi all,

I get data from a static source like erp kind application and finally we recieve the source as a flat file ex.txt. these static files are uploaded in QV..

but my requirement is few columns of these data needs to be updated or changed sometimes. I Will not be able to go back to my source.

any other ideas here. For example using an excel i could edit the values in QV

[#2]

Hi Raad,

it's possible to set manually the table fields ,
just count the positions .

See the Example

[raadwiptec]

hi paola. manual is not possible. it is a big file sometime changes are enormous

[#4]

Hi Raad,You have to do it only for headers!!!

[raadwiptec]

hi xia,

i cannot have the same name references in the same load..

[syukyo_zhu]

Hi,

i'm not sure understand well your said, But in my example i haven't same field.

If yes, you can do these

name it as reference _new,

then,

drop field reference from yourtable;

rename field reference _new to reference

so you can juste keep one field "reference" in your table target.

[raadwiptec]

hi paola

yes its a pivot table for ex

10000121 ¦ 54656454545646 ¦ 23000.22 ¦ XFD656565 - As Xia said  if it is changing XFD777777 then other values - 10000121 ¦ 54656454545646 ¦ 23000.22 ¦  should go under the  new reference