.csv after generating reports id change

Help Something Else
1

hi . i’m generating .csv file and when i generate .csv file some id change into

image
image187×657 70.5 KB

the source id is not like this . but after generating the first process. the id’s change. then i can’t match the other id’s…

need help :frowning: so bad

2

Hi @ldiaz

Can you share the input and how did you change the format to csv?

Cheers

3

i already have the .csv file the id’s is good but after generating the report the id’s mess up then i can’t match some id’s

4

the format is already .csv sir

5

Hi @ldiaz

What do you mean by generating?

from where are you generating the csv from?

Is it possible to share the input file or the xaml file please

chees

6

the first process is comparing 2 dt
the .csv and the .xlsx
if the id match. the process will do something in the .csv
after the for each write csv
the i will read again the .csv for the next case
but after the first case some of the ids in the .csv is messed up

image
image187×657 70.5 KB

7

Hi @ldiaz

I guess youa re using some cint or something in process for comparing the values and it is actually rounding off i guess.

Is it possible to share the xaml or check if any manipulations are happening or if you are rounding off the values

cheers

8

image
image1511×743 45.2 KB

9

im not moving or doing something in the column of ids just finding if have match in the other id

10

@ldiaz

If you are not manipulating anything then may I know why are you writing it back?

and when you are writing what is the column type of the target column in the datatable?

cheers

11

in column id i don’t manipulating anything

sometimes the other column i change them to cdbl so i can sum or minus something then convert again to string

12

@ldiaz

Its sure that the value is getting manipulated…is the column type in datattable is of type int32 or cdbl for the target column?

Is it possible to share the xaml or the csv atleast.

To confirm use a log message after the manipulations that you are doing and print thw required column value and see where it is getting modified

Cheers

13

hello @ldiaz
make sure, when writing the csv file you are choosing the comma as separator/delimiter, if you are using the tab as delimiter then it could be the reason for your error.

14

hi i just checked all the read and write. all delimiter is set to comma

15

Adjustment_MSME2.xaml (472.1 KB)
here sir.

16

Hi @ldiaz

I have gone through it…as per my view i couldnt see any differenc eother than add quotes option checked.

And as i cannot run it, can you add log messages and check where exactly the column is getting modified?

Or run in debug and for every step try checking the datatable if it is modified

Cheers

17

hi i solve the issue by adding (') in every id in .csv
in the end of id
how can i match now the id’s from from dt1(.csv) to dt2

18

Hi @ldiaz

When you retrieve do a replace and then match it.

Cheers

19

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.