Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Raad,
it's possible to set manually the table fields ,
just count the positions .
See the Example
hi paola. manual is not possible. it is a big file sometime changes are enormous
Hi Raad,You have to do it only for headers!!!
hi xia,
i cannot have the same name references in the same load..
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.
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